Forum Discussion
#VALUE error appears before data calculates
Created a great spreadsheet to measure distances and elevations for a local golf association. Very last step is rid the blank spreadsheet of the #VALUE error. Tried IFERROR w/o results. Using 365 ...
And which exactly formulas in AZ3 and AZ21 where you have an error?
I don't have any errors as far as I know ... everything calculates perfectly as designed once populated.
Just want the #VALUE to go away and leave a clean/empty cell for the end user before they populate with data. To them it looks like an error message before population when all the other cells are blank.
This spreadsheet is designed for 27 golf holes, the #VALUE appears 216 times in the entire spreadsheet: 27 holes * 8 Tees = 216 very noticeable #VALUE cells