Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
tjtjjtjt
 
Posts: n/a
Default hide #N/A in multiple cells

You formula shoule be:

=if(ISNA(Formula),"",Formula)

As you wrote it, you were missing the comma before the second formula.
Also, make sure you only have a = at the beginning of the formula.
--
tj


"Pete Elbert" wrote:

Cells have formulas set up in them and will not be used until the cells in
column A have a reference in them. The formula in most all of the cells look
something like this: =VLOOKUP($A6,$A$106:$CB$148,2,FALSE) Someone stated
that =if(ISNA(Formula),""Formula) would work, however, everytime I try to
apply it, I must be doing something wrong because I continue to get an error
message on the screen. Can anyone help?

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
hide #N/A in multiple cells Pete Elbert Excel Discussion (Misc queries) 0 March 26th 06 11:55 PM
hide #N/A in multiple cells Pete Elbert Excel Discussion (Misc queries) 1 March 26th 06 11:52 PM
hide #N/A in multiple cells tjtjjtjt Excel Discussion (Misc queries) 0 March 26th 06 11:45 PM
link multiple cells to multiple cells jpoltor Excel Discussion (Misc queries) 1 March 22nd 06 08:10 AM
how can i ignore blank cells when multiple cells? arash Excel Worksheet Functions 4 November 17th 05 04:35 PM


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

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

About Us

"It's about Microsoft Excel"