e.g

Sarah Hill got 50 sales but only 98% i want i a sum that does this bit for
me

=250 (she get 5 for evey sales)

if she had 100% then she woulf have got 500

100 = 10
99 and below= 5

this ne u have give does not work can u help plz

"Loris" wrote:

ASSUMING THE PERCENTAGE TOTAL IS LOCATED IN CELL "A3", YOUR FORMULA WOULD
READ: =IF(a3<1,5,10)

"TYE" wrote:


can you help on this
If some only get's 99% or less than they get 5 for every sale but if they
get 100% than they get 10