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.

Thank you.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!