Excel calculation help

[Hanzs]

Hi, am trying to put a calculation (excel office 2007) that looks at for
example A20 and if this is greater than 10,000 then will multiply anything
above 10,000 at 0.25
or if it is lower than 10,000 then multiply the given number by 0.40
Please can you tell me what formula I need to use??!!
thanks
Han..

 

[Mike H]

Hi,

Your question is confusing. What you asked for is this
=IF(A20>10000,(A20-10000)*0.25,A20*0.4)

What you may have meant is this
=IF(A20>10000,A20*0.25,A20*0.4)

Mike

 

[David Biddulph]

It isn't entirely clear what you want, but from the way you have described
it, perhaps:
=IF(A20>10000,(A20-10000)*0.25,IF(A20<10000,A20*0.4,"whatever result you
want for A20 equals 10000"))

Adjust the formula to suit what you do want.