Trouble with an if/then math formula

[TRW Enterprises]

I'm still learning Excel and have watched countless videos trying to figure out this formula but can't find it.
I'm trying to add a specific percentage to each line of costs based on what range each number falls between numerically.
I need any number 0-74 to have 150% added, 75-99 to add 140%, 100-124 to add 135%, and anything 125 or higher to add 125%.
I need them in a side by side column so I can compare the original number to the new number.
I know this is a pretty lengthy formula and it's honestly still out of my grasp on how to do this one. Once I actually see it I believe it'll finally make perfect sense. Any help would be highly appreciated.
Thanks, Tony

 

[jtakw]

Hi,

This will work for what you described:

Excel 2010
	A	B
1	15	22.5
2	70	105
3	85	119
4	111	149.85
5	145	181.25
Sheet11

Cell Formulas
Range	Formula
B1	=IF(A1>124,A1*1.25,IF(A1>99,A1*1.35,IF(A1>74,A1*1.4,A1*1.5)))

B1 formula copied down.

 

[steve the fish]

You can use LOOKUP as well if you want. Something like:

=LOOKUP(A1,{0,75,100,125},A1*{2.5,2.4,2.35,2.25})

 

[TRW Enterprises]

Thank you both very much!! Priceless information!! Works brilliantly!!

 

[jtakw]

You're welcome, welcome to the forum.