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
-
Which column are you putting your formula in?
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"
-
Which column are you putting your formula in?
-
You ar correct. It was placed in the wrong column. Now it works!
Thank you very much!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!