How to write a formula in Excel

[HappyFace]

I want to write a simple formula to work out some commission but am struggling. Please help. Imagine cell A1 contains an amount of �240. I want column B1 to report back the commission so that if A1 was greater than �140 then multiply by 40%. If A1 was less than �140 then multiply by 25%. Thanks

[joanne713]

apparently its this! =if(A1>�140,A1*40%,A1*25%)

[gen2]

Are you sure we're not doing your IT homework for you?

=if(a1>140, A1*0.4,A1*0.25)

which translates as:
IF A1 is greater than 140, THEN multiply A1 by 0.4, ELSE multiply A1 by 0.25

[kempie]

...however, if exactly �140 also brings 40% commission then

=IF(A1>=140,A1*0.4,A1*0.25)

[HappyFace]

10 out of 10 guys and so quick with your answers. Thought I would have to wait until tomorrow.