Hide #N/A

[madocar]

Hello there,


Could u help me with my issue? I want to hide formula comment like "#DIV/0"

Last column consist of formula A/B and I would love to hide that comment #DIV/0 until I do put there some values in the next month (May).

I know it is possible doing it by using formulas, but there must be some simplier way how to set it up generally in excel.

[pre]

Date	        A	B	A/B
1.1.2013	100	2	50
1.2.2013	111	24	4,625
1.3.2013	44	2	22
1.4.2013	544	54	10,07407407
1.5.2013			#DIV/0!
1.6.2013			#DIV/0!
1.7.2013			#DIV/0!

[/pre]
Thanks

Mateus from Slovakia

 

[DaveTurton]

As far as I am aware it needs to be done with a formula.


Either:


Conditional formatting =iserror(reference) then format the font ec


or in cell


=if(iserror(reference),"")

 

[oldchippy]

Hi Mateus,


Welcome to the forum, there are a number of ways and here's one


=IFERROR(A1/B1,"")

 

[bobhc]

OP post edited with back ticks

 

[SirJB7]

Hi, madocar!

DaveTurton's formula (ISERROR function) works with 2003 and 2007+ Excel versions, olchippy's one (IFERROR function) works only with 2007+ versions.

Another way it's this:

=IF(C1=0,"",B1/C1)

Regards!


@oldchippy

Hi!

Couldn't find a shorter formula, tied in 18 this time

Regards!

 

[James Perry]

Hi Madocar!


=IF(ISERROR(Your Formula),"",Your Formula)