Can I use ISNA here (Excel 2002)

Topic

New Reply

Hi

This fomula =IF(AC7=0,””,AC7/Y7) returns #NA, is it possible to use ISNA to return a blank cell the same as you can in VLOOKUP?

Many thanks

Braddy

Reply | Quote

Replies

Something like this:
=IF(isna(ac7/y7),””,if(AC7=0),””,AC7/Y7))

This will not yield a blank cell, it will yield a cell containing a null string. It is not possible to have a blank (ie empty) cell if you put a formula into it.

Steve

Reply | Quote

Hi Steve

Thanks for the reply a null value is fine, however using your formula give me an error where the first “” are highlighted.

Thanks Braddy

Reply | Quote

There is one closing parenthesis too many. Try

=IF(ISNA(AC7/Y7),””,IF(AC7=0,””,AC7/Y7))

By the way, shouldn’t you test for Y7=0 instead of fot AC7=0?

Reply | Quote

Hi Hans

Your formula acheived what I am looking for.

incedently Y7 contains another formula, but I wil do some checking.

Thanks for your reply

Braddy

Reply | Quote

OOPS. Hans found/fixed my error. That is what I get for posting an “air-formula”…

Steve

Reply | Quote

Apparently, either AC7 or Y7 can house #N/A for the formula to evaluate to #N/A.

If you don’t want to clean up AC7 and/or Y7 for such an error, as an alternative, you can set up your formula in a positive mood…

=IF(ISNUMBER(AC7/Y7),AC7/Y7,””)

Reply | Quote