Help with a calculation!

P

pc2

Hi,

Was wondering if anyone can help me with a calculation I want to do.

Basically, I want to multiply a number by different percentage
depending on the value. So the excel needs to figure out the value
then multiply that value by the respective percentage.

Eg. <1999 - 150%
2000-2999 - 140%
3000-4999 - 135%
5000+ - 130%

I need exactly the values above.

Thanks,
PC2
 
A

Arvi Laanemets

Hi

=IF(YourValue<2000,1.5*YourValue,IF(YourValue<3000,1.4*YourValue,IF(YourValu
e<5000,1.35*YourValue,1.3*YourValue)))
 
Top