IF Function error

[G00dman]

Trying to create a 'Nested IF' function, (putting an IF statement in an IF statement) however it returns with the error of having too many arguments in this function.

The above is my formula.

I am entering this into cell M2

[#2]

Hi @G00dman,

Please try following formula in M2.  

=IF([@[Sales Person]]="M",[@Profit], IF([@[Sales Person]]="M/MPB",[@Profit]*0.8, 0))

Please note, the formula returns 0 (zero) if the sales person is neither M nor M/MPB. If you need some other value, please replace the zero in  red font with right value.  hope this helps!!