Multiplication with results of an IF Statement

Nick Burrus

Hello,

It appears you can't do calculations with the results of a nested IF statement?

 

=(IF([Shift Duration]1 = "2 Hours", "3.75", IF([Shift Duration]1 = "3 Hours", "2.5", "NA"))) * [Number]1

It appears I have to have the IF statement alone in one column, and then the math in another column. 

=IF([Shift Duration]1 = "2 Hours", "3.75", IF([Shift Duration]1 = "3 Hours", "2.5", "NA"))

=[Formula]1 * [Number]1

Is there a way to condense this down to one formula, or are we stuck with math in an if statement being two cells? 

Nick Burrus

Hello. The FAQ docs aren't clear.

 

The problem is I used "quotes" when you need a numerical value, drop the quotes. Smartsheet isn't smart enough to exclude it. It'd think it's a text based value.  

=IF([Shift Duration]1 = "2 Hours", "3.75", IF([Shift Duration]1 = "3 Hours", "2.5", "NA"))

should be

=IF([Shift Duration]1 = "2 Hours", 3.75, IF([Shift Duration]1 = "3 Hours", 2.5, "NA"))

Paul Newcome

That is correct. Using quotes generates a text string.