=num_sales*(IF(cell=100%,10,5))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"TYE" wrote in message
...
I Need a sum that works out the following,

if John Smith has got 3 sales and 100% then he will get £30 but if its
below
100% then he will get £15

100% = £10
Above 100% is £5

Can you help