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