Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Hiding #N/A
Can anyone help please with how to hide #N/A please?
I have tried conditional formatting but cant get the settings right. -- Kind Regards Mick --- Outgoing mail is certified Virus Free by AVG. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.802 / Virus Database: 545 - Release Date: 26/11/2004 |
#2
|
|||
|
|||
try this:
=IF(ISNA(yourFormula),"",yourFormula) KL "Mick" wrote in message ... Can anyone help please with how to hide #N/A please? I have tried conditional formatting but cant get the settings right. -- Kind Regards Mick --- Outgoing mail is certified Virus Free by AVG. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.802 / Virus Database: 545 - Release Date: 26/11/2004 |
#3
|
|||
|
|||
Thanks "KL"
I'm sorry I must be missing something. I have tried entering your suggestion in both conditional formatting and directly in a cell using "My Formula" and neither seem to work (most likely me at fault). Can you help further please? Regards Mick "KL" <lapink2000(at)hotmail.com (former ) wrote in message ... try this: =IF(ISNA(yourFormula),"",yourFormula) KL "Mick" wrote in message ... Can anyone help please with how to hide #N/A please? I have tried conditional formatting but cant get the settings right. -- Kind Regards Mick --- Outgoing mail is certified Virus Free by AVG. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.802 / Virus Database: 545 - Release Date: 26/11/2004 --- Outgoing mail is certified Virus Free by AVG. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.802 / Virus Database: 545 - Release Date: 26/11/2004 |
#4
|
|||
|
|||
Mick,
If for example your formula that returns #NA! is =VLOOKUP(A1,$B$1:$D$10,2,FALSE), then do this =IF(ISNA(VLOOKUP(A1,$B$1:$D$10,2,FALSE)),"",VLOOKU P(A1,$B$1:$D$10,2,FALSE)) Regards, KL "Mick" wrote in message ... Thanks "KL" I'm sorry I must be missing something. I have tried entering your suggestion in both conditional formatting and directly in a cell using "My Formula" and neither seem to work (most likely me at fault). Can you help further please? Regards Mick "KL" <lapink2000(at)hotmail.com (former ) wrote in message ... try this: =IF(ISNA(yourFormula),"",yourFormula) KL "Mick" wrote in message ... Can anyone help please with how to hide #N/A please? I have tried conditional formatting but cant get the settings right. -- Kind Regards Mick --- Outgoing mail is certified Virus Free by AVG. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.802 / Virus Database: 545 - Release Date: 26/11/2004 --- Outgoing mail is certified Virus Free by AVG. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.802 / Virus Database: 545 - Release Date: 26/11/2004 |
#5
|
|||
|
|||
Mick
Either trap for the error as KL shows or if you want to use CF....... Select the cell or cells to CF CFFormula is: =ISNA(cellref) Remove $ signs if Excel sticks them in cellref. FormatFontColorWhite OK your way out. Gord Dibben Excel MVP On Tue, 30 Nov 2004 09:09:13 -0000, "Mick" wrote: Can anyone help please with how to hide #N/A please? I have tried conditional formatting but cant get the settings right. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hiding info | New Users to Excel | |||
Hiding Formula in cells | Excel Discussion (Misc queries) | |||
Global hiding null rows | Excel Discussion (Misc queries) | |||
Hiding the Standard Toolbar | Excel Discussion (Misc queries) | |||
Conditional hiding of worksheets | Excel Discussion (Misc queries) |