Speaking for myself, I need you to rephrase your question. I'm missing
something. From your example, they can get up to 20 pts each per day. Easy
enough to test for <14 pts, but then what? Does Amy get half the points of
Chloe or Daniel or who?

"ycwkpp898" wrote:

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