Excel calculation help
 

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..

Excel calculation help
 

Hi,

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

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

Mike


"Hanzs" wrote:

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..

Excel calculation help
 

It isn't entirely clear what you want, but from the way you have described
it, perhaps:
=IF(A2010000,(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.
--
David Biddulph

"Hanzs" wrote in message
...
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..