Multiple IF functions Nested

Yeshaya

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.

Paul Newcome

Which column are you putting your formula in?

Mathieu PERSICO

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,

Yeshaya

I tried it, however I get an error "#Circular Ref"

Paul Newcome

Which column are you putting your formula in?

Yeshaya

You ar correct. It was placed in the wrong column. Now it works!

Thank you very much!

Paul Newcome

Happy to help. 👍️