Trying to return a figure depending on number of sales made

[mgmerv]

Hello,

In the attached sheet I'm trying to work out how to return a figure depending on the number of sales someone has made - If they have 3 or less sales they earn 2% of the fee if they have over that they get 3% on all sales I'd be grateful if someone could help me - I've attached the sheet and its cell M6 that I'm trying to get to work out.

Any help would be gratefully received.

[63falcondude]

You haven't included the expected results and also did not explain the Y or N but I'll take a guess at what you are looking for.

Try this in M6 =IF(L6="Y",IF(L$25<=3,F6*0.02,D6*0.03),0)

This formula returns 0 if L6 is blank or N. If L6 is Y, it returns 2% of the fee if L25 ≤ 3 and 3% of the sale price if L25 >3.

[TMS]

Maybe:

Please Login or Register  to view this content.