Simple "IF" - #UNPARSABLE

Simplest IF statement:


=IF(Type@row = "Software", [Weighted Forecast])


Type column has dropdown containing either "Software" or "Services" only.


Weighted Forecast column is calculated from Forecast and Probability.


I have much harder (and nested) statements in my sheet that work fine. Can figure out what it doesn't like about this one.

😀

Jason

Best Answers

Answers