This maybe to interest for DIABETICS

[SydneyGeek]

Thanks for catching that. There are a few things that will need tweaking so that the 97-2003 version doesn't lose too much of the look and feel of the 2007 template.

Denis

 

[cummingsea]

njimack said: I think you might need a separate file for xl 97-03, as the formula in cell I6 of the weekly sheets doesn't work.

I just tested average (I6) and it works on my machine with EXCEL 2007, I will test it on my Daughters machine with EXCEL 2003 PRO.

 

[njimack]

njimack said: I think you might need a separate file for xl 97-03, as the formula in cell I6 of the weekly sheets doesn't work.

I just tested average (I6) and it works on my machine with EXCEL 2007, I will test it on my Daughters machine with EXCEL 2003 PRO.

That's not the issue. The function IFERROR was introduced in Excel 2007. Prior versions display #NAME?

 

[cummingsea]

njimack said:That's not the issue. The function IFERROR was introduced in Excel 2007. Prior versions display #NAME?
You are correct about the IFERROR, that's why I said I would test it on my little girl's machine with EXCEL 03, so that I could see what was going on, once I opened the file and clicked on I6 I saw the problem with the IFERROR command, So I will see if I can remember which Formula to use in EXCEL 03 to correct the probleam.
Thanks njimack for catching that error, being that I use EXCEL 07 it did not show the error.

 

[Dave Patton]

You could revise I6 to

=IF(ISERR(AVERAGE(Week1!$E$4:$E$17)),"",AVERAGE(Week1!$E$4:$E$17))

hth Dave