Multiple IF functions Nested
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.
Help Article Resources
Check out the Formula Handbook template!