Multiple IF functions Nested
Hello,
I would like to Nest two If functions in one cell. Below is what I have, but I am receiving an error #unparseable.
=IF([Sales Person 1]2667 = "Y", ([Net Profit]2667  100) * 0.5, IF([Commission due]2667 > 0, "0" )), ([Net Profit]2667  100) * 0.4)
I would greatly appreciate your help.
Thank you.
Best Answer
Answers

Hi @Yeshaya,
A misplaced parenthesis. Try this:
=IF([Sales Person 1]2667 = "Y", ([Net Profit]2667  100) * 0.5, IF([Commission due]2667 > 0, "0", ([Net Profit]2667  100) * 0.4))
Have a good day,
Mathieu  Workflow Consultant

I tried it, however I get an error "#Circular Ref"


You ar correct. It was placed in the wrong column. Now it works!
Thank you very much!

Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!