Current location - Recipe Complete Network - Catering training - How to use the function of excel to make salary commission report?
How to use the function of excel to make salary commission report?
Suppose the reserve price is A 1, the selling price is B 1, the quantity is C 1, and d1= if (b1> A 1,(b 1-a 1)* c 1 * 0.3,if(B 1=A 1,B 1*C 1*0.0 1,"")

Here, if the selling price is lower than the reserve price, the result is empty.

In addition, 1000*30%=333.3 This is not right, should it be 300?