What's wrong with my "IF" formula?

Lisa Matthews2

Hello,

I wrote this formula to populate a cell based on info in a different cell. I keep getting the "UNPARESEABLE" message. Please help! What am I missing in this formula?

Thank you, in advance!

--Lisa

Lisa Matthews2

Hi John,

Thank you so much! I just copied your formula into my sheet and it worked beautifully!

John Walden

Hi Lisa,

Try removing the spaces between the IF (Influence...). i.e., IF(Influence@row = "High", 3, IF(Influence...

Also, you'll need another ) at the end of the formula.

=IF(Influence@row = "High", 3, IF(Influence@row = "Medium", 2, IF(Influence@row = "Low", 1, IF(Influence@row = "None", 0))))

Lisa Matthews2

Hi John,

Thank you so much! I just copied your formula into my sheet and it worked beautifully!