Excel help , please

[amy21322]

Hi,
Hope someone can help me with an Excel formula.
In a spreadsheet I'm toying with, I have 4 relevant cells.
E19 = 400000
E28 = 20000 (this is a variable figure anywhere from 0 upwards)
E29 = E28 - 10000 (This formula is OK)
E32 = X
If E29 > 10000, then E32 = E19 - 10000....but
If E29 < 10000, then E32 = E19
Is there a formula I can use at E32 that covers my requirements?
I have tried for hours, so would appreciate any help.
Cheers
Amy

 

[tess85]

Hi Amy

Try
=IF(E29>10000,E19-10000,E19)

Out of curiosity, what do you want the answer to be if E29 = 10,000? Because the formula might then change to:
=IF(E29>=10000,E19-10000,E19)

(note the additional equal sign)

 

[amy21322]

Hi, Tess,
Many thanks for your reply.
=IF(E29>10000,E19-10000,E19) looks good, as it refers to an amount in excess of 10000.
Thanks for pointing that out, too. (ie >=). I didn't think about that.
Appreciate your help.
Cheers
Amy