Multiple IF conditions to calculate percentage value

[angelocyrl]

Hi!

Here is the values and conditions:

[TABLE="class: grid, width: 200"]
<tbody>[TR]
[TD][/TD]
[TD="align: center"]A
[/TD]
[TD="align: center"]B
[/TD]
[TD="align: center"]C
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Customer
[/TD]
[TD="align: center"]Target
Achieved
[/TD]
[TD]Commission
[/TD]
[/TR]
[TR]
[TD="align: center"]2
[/TD]
[TD]Bernard[/TD]
[TD]54882[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]3
[/TD]
[TD]Norbert[/TD]
[TD]13420[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]4
[/TD]
[TD]Maggie[/TD]
[TD]91472[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: center"]5
[/TD]
[TD]Smilly[/TD]
[TD]33542[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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.