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
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!!