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

Haithem

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

Haithem

what about this one?

=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

J. Craig Williams

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