#### Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

# if statement

Options

Hello,

I am trying to make an "if statement" but I got no luck.

I don't know how to start, I tried with

=IF(sqf1 > "32", "width1*hight1*5.5", "sqf1 < "32""width1*hight1*8.5") I know its looks bad

Thank you

• Options

hi Haithem

you're not too far off.

By using "" you are telling Smartsheet that 32 is text. You also need to consider what you want to happen if your sqft is actually 32 as this would not trigger either condition.

I've assumed you want to multiply by 5.5 if the sq ft is 32 So the final formula is

=IF(sqft1 >= 32, width1 * height1 * 5.5, IF(sqft1 < 32, width1 * height1 * 8.5))

Forgive me but I noticed you'd spelt height as hight so for the formula to work you'll need to change your column header to height

cheers

Mark

• Options

Thanks a lot Mark! that works with me.

I don't know why I cant give your comment a Like or a reply. Thanks anyway

• Options

=IF(Type37 = "feet", IF(sqft37 >= 32, width37 * height37 * Qty37 * 5.5, IF(Type37 = "feet", IF(sqft37 < 32, width37 * height37 * Qty37 * 8.5, IF(type37="inches", IF(sqft >=32, width37*height37*qty37*5.5, IF(type37="inches" , IF(sqft37<32, width37*height37*qty37*8.5))))))))

where is the error? I am so confused

• ✭✭✭✭✭✭
Options

It might be here:

=IF(Type37 = "feet", IF(sqft37 >= 32, width37 * height37 * Qty37 * 5.5, IF(Type37 = "feet", IF(sqft37 < 32, width37 * height37 * Qty37 * 8.5, IF(type37="inches", IF(sqft37 >=32, width37*height37*qty37*5.5, IF(type37="inches" , IF(sqft37<32, width37*height37*qty37*8.5))))))))

I did not create a test case.

Craig

This discussion has been closed.