Provide me the IF function for obtaining sales commission?

loveandloveonly

New member
Joined
Mar 12, 2009
Messages
1
Reaction score
0
Points
1
Situation is as follows
Sales: upto 10,000 - no commission, 10001 to 25000 - 10% of sales exceeding Rs. 10000, and for Rs. 25001 to 50000, 20% for the amt exceeding Rs. 25000 and normal commission as applicable for 10001 to 25000
(For Example; commission for sales of Rs. 35,000 will be Rs. 3500)
 
Back
Top