Hiding error formulas in spreadsheet

[Crofton]

Version: 2008

Can you please help

I am trying to hide error messages that show within a spreadsheet.

Currently when I 'drag' a formula to complete the rest of the columns for automatic infilling it displays the hash sign plus DIV/0!.

The formula is right and doing what it should do but is there a way I can 'turn off' the error display in the cell so it is blank until populated.

Many thanks

 

[Bob Greenblatt]

Version: 2008

Can you please help

I am trying to hide error messages that show within a spreadsheet.

Currently when I 'drag' a formula to complete the rest of the columns for
automatic infilling it displays the hash sign plus DIV/0!.

The formula is right and doing what it should do but is there a way I can
'turn off' the error display in the cell so it is blank until populated.

Many thanks

Unfortunately no, you can't turn this behavior off. However, you can
accomplish the same thing with a slightly different formula. Try this
(adjusted for your columns, of course):
=if(a1=0,"",b1/a1)

 

[CyberTaz]

A couple of other options:

Use the formula: =IF(ISERROR(cellref),"No Data",cellref) Of course you can
substitute anything you prefer between the quotes as the Value_If_True or
just use "".

Use Conditional Formatting: Choose "Formula Is:" from the dropdown then
enter the formula =ISERROR(cellref) & choose white as the Font color.

NOTE: [cellref is the cell you're putting the IF() function in or applying
the Conditional Formatting to]

 

[CyberTaz]

Sorry - hadn't had the 2nd cup of coffee - the first suggestion should more
accurately have been:

=IF(ISERROR(your formula),"No Data",your formula)

--
Regards |:>)
Bob Jones
[MVP] Office:Mac

A couple of other options:

Use the formula: =IF(ISERROR(cellref),"No Data",cellref) Of course you can
substitute anything you prefer between the quotes as the Value_If_True or
just use "".

Use Conditional Formatting: Choose "Formula Is:" from the dropdown then
enter the formula =ISERROR(cellref) & choose white as the Font color.

NOTE: [cellref is the cell you're putting the IF() function in or applying
the Conditional Formatting to]

--
HTH |:>)
Bob Jones
[MVP] Office:Mac

Version: 2008

Can you please help

I am trying to hide error messages that show within a spreadsheet.

Currently when I 'drag' a formula to complete the rest of the columns for
automatic infilling it displays the hash sign plus DIV/0!.

The formula is right and doing what it should do but is there a way I can
'turn off' the error display in the cell so it is blank until populated.

Many thanks