S
SAMBASIVARAO RAVI
Sales (in units) 100 200 300 400 500 600 700 800 900 1000 1100
Commission (per unit) 0 3 4 5 6 7 8 9 10 11
12
above sales slabs and commission per unit has given. if any person sold up
to 100 units commission his comission shoud be 0, if a person sold between
101 to 200 then his commission should be Units * 3, if a persons sold between
201 to 300 then his commission should be Units * 4 like that a person will
get commission on sales.
for the above i want to use a if condition to calculate commission. for that
i have to use 10 if conditions in a formula but it is accepting up to 7 if
conditions only in a formula
please show the solution for the above
Commission (per unit) 0 3 4 5 6 7 8 9 10 11
12
above sales slabs and commission per unit has given. if any person sold up
to 100 units commission his comission shoud be 0, if a person sold between
101 to 200 then his commission should be Units * 3, if a persons sold between
201 to 300 then his commission should be Units * 4 like that a person will
get commission on sales.
for the above i want to use a if condition to calculate commission. for that
i have to use 10 if conditions in a formula but it is accepting up to 7 if
conditions only in a formula
please show the solution for the above