Hi

You cannot let A2 = A2 - 30000 or whatever. A2 = A2.
To solve your problem, you need to use another cell, in which a formula may
insert a value, and then let A2 = the value of that cell - 30000/1000 etc
--
ve_2nd_at. Randburg, Gauteng, South Africa


"dom" wrote:

Hi,
I need help with this formula
A1 = value x
IF A1 <= 30000 Then A2=420.00
IF A1 =30000, but <=45000 then A2=(A2-30000/1000)*7.25+420.00
IF A1=45000, but <100000 then A2=(A2-45000/1000)*6+528.75
And so on

Could you get me past these steps?
If I type 30000 I should get 420 for an answer
If type 40000 my answer should be 492.50
If type 50000 my answer should be 558.75
Thanks