Reading Age Problem with minus Ages

Hi,

I have a problem with trying to calculate the correct reading ages when children have a reading age below their actual chronological age.

The attached data shows actual ages and calculates reading ages by comparing the two.

When the reading age is higher than the actual age, the result is correct. However, when the reading age is lower than the actual age, I get anomalies.

For example, in the test data, cell B4 shows an actual age of 6 Years and 3 Months and a reading age of 6 years and 4 months (D4) which calculates to a reading age difference of 0 years and 1 month (E4).

However, when you look at a reading age which is lower than the actual age, I get wrong results.

For example, in the test data, cell B5 shows an actual age of 6 Years and 8 Months and a reading age of 6 years and 7 months (D5) which should calculate to a reading age difference of minus 0 years and 1 month but incorrectly calculates to a reading age difference of 0 years and 11 months (E5).

I would like to say that the formula already in the test data has kindly been supplied by people in this forum.


I hope someone can help me with this.

Many thanks

Maybe try this until you get a better answer:

Formula:

Please Login or Register  to view this content.

You're welcome. Thanks for the rep.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.