Thread: SUM
View Single Post
  #1   Report Post  
TYE
 
Posts: n/a
Default SUM

I Need a sum that works out the following,

if John Smith has got 3 sales and 100% then he will get £30 but if its below
100% then he will get £15

100% = £10
Above 100% is £5

Can you help