2 Replies Latest reply: Oct 8, 2013 7:26 PM by Steppenwolf323
Steppenwolf323 Level 1 Level 1 (10 points)

Hi

 

I am creating a Blood Glucose Monthly Form. It is organized by week with an average at the end of each week for the various times of day I test my sugar. Those results then contribute to averaging the weekly numbers for a monthly number. I have a similar form I am developing for Blood Pressure.

 

My question is that since this a monthly form destined to be a template how do I get around the error messages that appear when there are blanks as I have not yet reached that day/ date. Can someone help with a formula that will work?

 

Thank you

 

Herbert