This content has been marked as final.
Show 3 replies

1. Re: #VALUE! error
GlennS_3 Aug 2, 2012 5:08 PM (in response to 952013)There are two possible ways around this (this if you consider changing from HSGETVALUE to grid retrievals)
1. In the Options, change the #missing, Zero Value and #Invalid replacements to either #numericzero or to (0)
2. In the hsgetvalue formula wrap the formula in N(HSGET....) so it would be =n(hsgetvalue,connection,dim,dime......) N() in excel says to take any nonnumeric data and replace it with zero. The downside to this is it will mask other formula errors 

3. Re: #VALUE! error
GlennS_3 Aug 2, 2012 8:59 PM (in response to 952013)N() does work. To prove it, in a spreadsheet add to cell A1 the text AAAAA and to cell B1 the value of 2. In cell A3 put in the formula =A1 + B1 you should get back #Value now change the formula to =N(A1) + N(B1) you should get back the value of 2. It works the same way for HSGetValue formulas, you must have the syntax wrong