Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 23rd 08, 02:19 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 176
Default 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   Report Post  
Old 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
Default 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   Report Post  
Old June 23rd 08, 03:06 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 176
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 03:40 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017