Good afternoon,
First time posting here, I am working on excel and have a formula to average multiple cells on a different sheet onto the home sheet for a summary page (creating data forms for teaching).
My formulas work to average: =AVERAGE(B.4!G4:J4)
However, there are MANY cells with formulas so I am concerned that teachers will avoid using the form due to the flood of =DIV/0! covering the page. How can I make these cells that do not possess a numerical value appear blank or have a - until the beginning formulas have information in them to populate with?
Thanks for the help!
Bookmarks