ExcelBanter

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - SUM (https://www.excelbanter.com/excel-worksheet-functions/50597-sum.html)

TYE

SUM

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

Bob Phillips

=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

All times are GMT +1. The time now is 07:33 PM.