SUM

T

TYE

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
 
B

Bob Phillips

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

--

HTH

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