SumIF

T

TYE

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
 
L

Loris

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

TYE

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
 
P

PCLIVE

Percentage in A1.
Number of sales in B1
Formula in C1

=IF(A1<100,B1*5,B1*10)

HTH,
Paul
 
Top