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

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

i want to divide the total points across each child. so i give away the full
points.
Points 300

Name done points
Amy 10 37.5
Chloe 15 112.5
Daniel 18 112.5
Emma 9 37.5

that would be the right points. until i give them another done mark

hope this helps.
and ty for the reply
"John Galt" wrote:

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

To come up with a solution more information is required about the calculation
of the points awarded. Your example shows 4 children and points are awarded
their share of the 300 points in a ratio of 1:3. Assuming that you in fact
have more than 4 children how do you award the points? Do you use the same
principle i.e. 15 children would be awarded in the ratio of 1:14?

"ycwkpp898" wrote:

i want to divide the total points across each child. so i give away the full
points.
Points 300

Name done points
Amy 10 37.5
Chloe 15 112.5
Daniel 18 112.5
Emma 9 37.5

that would be the right points. until i give them another done mark

hope this helps.
and ty for the reply
"John Galt" wrote:

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

Had further thoughts:
Assuming your table is:
Column A "Name", Column B "done" and column C "points"
Insert three rows above your table,
Column headings are now in row 4
Then cell A1 type in "Number of points"
Cell C1 enter 300
Cell A2 type in "Number below 14"
Assuming your list of names goes down to row 20 in
Cell C2 enter formula =COUNTIF(B5:B20,"<14")
Cell A3 type in "Number above 14"
Cell C3 enter formula =COUNTIF(B5:B20,"=14")
Your column Headings are in row 4
In cell C5 (replacing the current number) enter formula
=IF(B5="","",IF(B5<14,C$1/(C$2+(C$3*3)),C$1/(C$2+(C$3*3))*3))
and copy down to row 20
This will give you the results shown in your table and when you add names
and data to the bottom of the list the points distribution will adjust
accordingly.
You can of cours alter 20 to suit the number of rows you require.
Hope this helps



"Ron@Buy" wrote:

To come up with a solution more information is required about the calculation
of the points awarded. Your example shows 4 children and points are awarded
their share of the 300 points in a ratio of 1:3. Assuming that you in fact
have more than 4 children how do you award the points? Do you use the same
principle i.e. 15 children would be awarded in the ratio of 1:14?

"ycwkpp898" wrote:

i want to divide the total points across each child. so i give away the full
points.
Points 300

Name done points
Amy 10 37.5
Chloe 15 112.5
Daniel 18 112.5
Emma 9 37.5

that would be the right points. until i give them another done mark

hope this helps.
and ty for the reply
"John Galt" wrote:

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