MS Excel help needed...please

[low-standards]

Hello, I am messing around with Excel and trying to get a cell to display a certain amount from another cell. However it goes beyond my basic knowledge of adding cells.

Here is my deal:

I sell a product and want the new cell to show me my estimated commissions. However, I don't get paid for each product until I sell 20 or move of the product. So I need a formula which doesn't add the first 20 sales but will take sell 21+ in to account.

any help would be great =IF you don't mind.

thank you

[Lord Vetinari]

You need something like this
=IF(A2>20, (A2-20)*5,"")
A2 contains the sales, 5 is the commision

[low-standards]

i will give it a shot!! and then post result.

[low-standards]

it worked.