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



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



  • Jerrold Green1 Level 7 (29,960 points)



    There is a function named "IFERROR" that will trap an error condition, prevent the alert and substitute a display/calculation that you choose. The syntax is: =IFERROR(original-expression, what-to-do-upon-error).


    Often it is sufficient to display a null string on error: IFERROR(original-expression, "").



  • Steppenwolf323 Level 1 (10 points)



    I solved my own problem. I just don't know how. I opened a spreadsheet in Numbers I created in Excel with the formulas I needed and then saved it in Numbers format. It works perfectly.