Forum Discussion
#VALUE error appears before data calculates
Sergei, thank you for your reply! I noticed I can remove all but one set of " " and the formula works perfectly fine yet the #VALUE still exists. (I've attached a screen shot for further clarity.)
Desired results:
1) No data --> No #VALUE or a blank cell
2) Data entered --> Population of proper value from formula (e.g., +40, +30, +20 ... -30, -40)
G10's formula: =IF(AN10=",",AN10)
K10's formula: =IF(($G32-G10)>=35,+40,
IF(($G$32-G10)>=25,+30,
IF(($G$32-G10)>15,+20,
IF(($G$32G10>=+10,
IF(($G$32-G10)>-10,” “,
IF(($G$32-G10)<=-35,-40,
IF(($G$32-G10)<=-25,-30,
IF(($G$32-G10)<=-15,”-20,-10))))))))
AN10's formula: =IFERROR(VLOOKUP(AM10,$AW$2:$AZ$700,4,0),"")
AZ3 is a Value
G32's formula: =IF(AN32=",",AN32)
AN32's formula: =IFERROR(VLOOKUP(AM32,$AW$2:$AZ$700,4,0),"")
AZ21 IS A VALUE
If I can supply further information, let me know.
Thanks, ProTee
And which exactly formulas in AZ3 and AZ21 where you have an error?
- ProTeeJan 15, 2021Copper Contributor
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