if statement

Haithem

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

Mark Fay

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