Difference between two ages

[andypandypoo]

Firstly thank you so much for the response to my first issue... now i'm over that hurdle I've hit another wall.

I am trying to calculate the difference between chronological age and reading age.... I have a formula (pic 1) but when the reading age ends up being an age without a month value it throws out an error message.

Any help will be greatly appreciated.

A frustrated primary school teacher Mr G

 

[Fluff]

What are the ages meant to represent?
Your formula is treating 6.2 as 6 years 2 months, but at the same time it treats 9.09 as 9 years 9 months. They both can't be right.

 

[andypandypoo]

What are the ages meant to represent?
Your formula is treating 6.2 as 6 years 2 months, but at the same time it treats 9.09 as 9 years 9 months. They both can't be right.

ah well spotted - it should be 6.02 and 9.09.
This is the formula I have used to calculate the age:

 

[Toadstool]

Hi AndyPandyPoo,

I'm not sure of the math but it seems you're treating numeric as text. Is this the desired result?

AndyPandyPoo.xlsx
	E	F	G	H	I	J	K	L	M
6	Chron Age							Reading Age	Dif
7	7.0							7.08	8
8	6.2							9.09	43
9	6.4							12.08	76
10	6.2							9.00	34
Sheet1

Cell Formulas
Range	Formula
M7:M10	M7	=(INT(L7)*12+((L7-INT(L7))*100)-(INT(E7)*12+((E7-INT(E7))*10)))

 

[Fluff]

ah well spotted - it should be 6.02 and 9.09.

In that case how about

=(DOLLARDE(L4,12)-DOLLARDE(E4,12))*12