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!