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

=IF(A1<100%,5,10) assuming your data is in A1

--
Ian
--
"TYE" wrote in message
...

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

One way:

If the % is in A1, and number of sales in A2,

=5*(1+(A1=1))*A2

In article ,
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

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

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

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

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

HTH,
Paul

"TYE" wrote in message
...


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