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