Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
=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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|