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
info@evolytion.com
-
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!