On 2002-03-14 10:33, rambollet wrote:
What is the syntax for entering the error value #N/A within a logical test, as in =IF(G2=#N/A),0,G2).
I've tried entering it with and without "" but no improvement.
Any error value can be returned as 0.
On 2002-03-14 11:38, rambollet wrote:
Thanks so much....again. Less complicated than what I eventually came up with.
Before I read your reply I discovered ERROR.TYPE function and ERROR.TYPE return values and was able to use it to denote #N/A in the logical argument, as in
IF(ERROR.TYPE(G2)=7,0,G2), where 7 is the error return value for #N/A.
(Not that you didn't know but for the benefit of readers who are less gifted as myself)