Multiple IF Statement giving an #UNPARSEABLE error.

Matthew R

=IF([QTY 1]@row = "", "0"), IF([QTY 1]@row = "1", "1246"), IF([QTY 1]@row = "2", "2492")

This formula is currently returning as #UNPARSEABLE

I have a helper column that is my "QTY 1" column, as this increases I would like the "Price per" column to double in price.

Prices stay pretty static and change very rarely.

I feel like I might be missing something small in this instance, or perhaps tackling this from the wrong angle.

Thank you for any help you can provide Smartsheet Community!

Razetto

@Matthew R I changed it to read as blank and moved the parenthesis; see if this one works =IF(ISBLANK([QTY 1]@row), "0", IF([QTY 1]@row = "1", "1246", IF([QTY 1]@row = "2", "2492")))

Razetto

@Matthew R I changed it to read as blank and moved the parenthesis; see if this one works =IF(ISBLANK([QTY 1]@row), "0", IF([QTY 1]@row = "1", "1246", IF([QTY 1]@row = "2", "2492")))

Matthew R

WORKED PERFECTLY! Can not thank you enough.

I see the switching of the parenthesis in the first @row and the addition of the (ISBLANK is something I did not even think about.

Thank you for the education!!