Help with a calculation!

  • Thread starter Thread starter pc2
  • Start date Start date
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
 
Hi

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