I need to get rid of this error. My formula is as follows:
=+(Data!X8+Data!X9+Data!X10)/((Data!G8+Data!G9+Data!G10)-(Data!AO8+Data!AO9+Data!AO10))
All of the Data comes off a data spreadsheet and is then formulated into a
different spreadsheet. I don't yet have all the data on the data spreadsheet,
however I will not be entering it and I need to have the formulas already in
place to automatically populate once the data is entered. Currently the data
for the above formula is this:
X8=0, X9=0, X10=0, G8=0, G9=0, G10=0, AO8=0, AO9=0, AO10=0. Can anyone help
me to hide this error message until the data changes?
Thanks!