Remember Me?

#1
June 23rd 08, 02:19 AM posted to microsoft.public.excel.newusers
 external usenet poster First recorded activity by ExcelBanter: Aug 2006 Posts: 176
IF and #N/A

Hi

I run Excel 2K

I have a VLOOKUP table that returns the value of #N/A in some cells. This is
not a problem.

I am looking to have a formula in an adjacent cell that looks at the #N/A
and returns somthing like this:

=IF(L112=#N/A,"NO","YES)

(I have tired this but it returns the value of #N/A)

I have also tried =IF(VALUE(L112)=#N/A,"NO,"YES) but thie returns #VALUE!

I have also tried putting the #N/A in inverted commas ("#N/A") but this also
does not work.

Any Ideas?

Thanks

John

#2
June 23rd 08, 02:43 AM posted to microsoft.public.excel.newusers
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 35,218
IF and #N/A

You can use:

=if(isna(l112),"no","yes")

John Calder wrote:

Hi

I run Excel 2K

I have a VLOOKUP table that returns the value of #N/A in some cells. This is
not a problem.

I am looking to have a formula in an adjacent cell that looks at the #N/A
and returns somthing like this:

=IF(L112=#N/A,"NO","YES)

(I have tired this but it returns the value of #N/A)

I have also tried =IF(VALUE(L112)=#N/A,"NO,"YES) but thie returns #VALUE!

I have also tried putting the #N/A in inverted commas ("#N/A") but this also
does not work.

Any Ideas?

Thanks

John

--

Dave Peterson
#3
June 23rd 08, 03:06 AM posted to microsoft.public.excel.newusers
 external usenet poster First recorded activity by ExcelBanter: Aug 2006 Posts: 176
IF and #N/A

Thanks Dave !

"Dave Peterson" wrote:

You can use:

=if(isna(l112),"no","yes")

John Calder wrote:

Hi

I run Excel 2K

I have a VLOOKUP table that returns the value of #N/A in some cells. This is
not a problem.

I am looking to have a formula in an adjacent cell that looks at the #N/A
and returns somthing like this:

=IF(L112=#N/A,"NO","YES)

(I have tired this but it returns the value of #N/A)

I have also tried =IF(VALUE(L112)=#N/A,"NO,"YES) but thie returns #VALUE!

I have also tried putting the #N/A in inverted commas ("#N/A") but this also
does not work.

Any Ideas?

Thanks

John

--

Dave Peterson

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

All times are GMT +1. The time now is 09:09 PM.