Thread: SumIF
View Single Post
  #3   Report Post  
JE McGimpsey
 
Posts: n/a
Default

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