Multiple IF conditions to calculate percentage value

[angelocyrl]

Hi!

Here is the values and conditions:

	A	B	C
1	Customer	Target Achieved	Commission
2	Bernard	54882
3	Norbert	13420
4	Maggie	91472
5	Smilly	33542

<tbody>
</tbody>

Coniditions:

Target < 15000 commission is '0'
Target > 15000 < 30000 is 2% calculate commission value
Target > 30000 < 45000 is 3% calculate commoission value
Target > 45000 < 60000 is 4% calculate commission value
Target above > 60000 is 5% calculate commission value

Display commission value in C column

Thank you in advance.

 

[admiral100]

Hi,

Not elegant but work...and drag down as needed

=IF(B2<15000,0,IF(B2<30000,B2*0.02,IF(B2<45000,B2*0.03,IF(B2<60000,B2*0.04,B2*0.05))))

 

[angelocyrl]

Thanks admiral. I tried but not working.

 

[admiral100]

Do the numbers really numbers in column B, perhaps Dates ? any errors ?
Its work for me ...

 

[Oeldere]

I advice you to use VLookup for this kind of work.