View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ycwkpp898 ycwkpp898 is offline
external usenet poster
 
Posts: 12
Default Suming to see if its below 14 and then award half the points

hi i am trying to set up a reward scheme for my children
i award 20 points each day to them, i want to work out the actual points
they have got each. and if they below 14 then they only get half the points
to the others.

Points 300

Name done points
Amy 10
Chloe 15
Daniel 18
Emma 9

ty to anyone who helps