Formula Needed

[CRAIG20]

Hi

I need a formula please for a cell B1. I have a number in cell A1. If the number is greater than 25000 I would like it to put the 10% of the amount in B1. If it is less than 25000 I would like it to just enter whatever amount is in cell D1 into B1.

Thanks

 

[VoG]

Try

=IF(A1>25000,A1*0.1,D1)

 

[CRAIG20]

Great. Thanks VoG

 

[CRAIG20]

Hi. Sorry to bother you. I need another formula for cell B31. If the figure in cell B27 is 70 I need it to multiply B31 by 0.7 If the figure in B27 is 90 I need it to multiply B31 by 0.9

Thanks

craig

 

[Clonemonkey]

hang on, do you want a value in B31 to be altered after it is populated? If B31 is calculated then just add "*(B27/100)" to the formular. If however it is user entered then you will probably need a macro to alter it once entered.
Eg. if B31= SUM(B28:B30) then add to it: B31=SUM(B28:B30*(B27/100)