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