One more formula problem

[slats432]

I would like to plug in a number and if it is between 50,000 and 100,000 I would like to multiply the amount over 50,000 by .01, if it is higher than 100,000 I want it to be .03 of greater than 100,000 plus 500.

If the number is 90,000, the result should be .01 x 40,000 which equals 400.
So if the number is 120000, the result should be 20000 x .03 plus 500.

Thanks so much...I hate being a newb...

 

[Paradigm_Shift]

If value you want to change is in A1, to return new value based on value in A1, enter this formula into A2:

=IF(AND(A1>50000,A1<=100000),A1*0.01,IF(A1>100000,(A1*0.03)+500,""))

And check your math on the 2 examples you posted...there is an error in both. But this formula's got you covered.

Happy Excelling!

 

[slats432]

Actually that doesn't work, probably because of my poor explanation.

If the number is between 50,000 and 100,000, then I want 1% of what is over 50,000.

If the number is over 100,000, then I want the amount over 100,000 x 3% plus 500.

If the number is 60,000, the correct number should be 100.(1% of 10,000).

If the number is 120,000, I want 3% of the 20,000 plus 500. The correct number would 1,100.

 

[Paradigm_Shift]

Oh, ok. Well, very simple modification to the original formula then:

=IF(AND(A1>50000,A1<=100000),(A1-50000)*0.01,IF(A1>100000,((A1-100000)*0.03)+500,""))

That should do it.

 

[slats432]

Thank you...works like a charm.