Thread
:
SumIF
View Single Post
#
3
JE McGimpsey
Posts: n/a
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
Reply With Quote