Getting rif of #DIV/0! 1

[haggis]

Hi all,

I picked up a good tip for suppresing 0's in blank cells and it worked a treat. (0.00;

Does anyone know if it's possible to get rid of the #DIV/0! in a cell. I know what's causing it, but dont want it displayed on my spreadsheet with no input.

Thanks in advance for any help.

 

[dsi]

You can use an If statement to see if the denominator is zero. If so, set the cell to an empty string otherwise display the result.

DimensionalSolutions@Core.com
While I welcome e-mail messages, please post all thread activity in these forums for the benefit of all members.

 

[warburton1]

One way of removing the DIV/O result is to use the IF and ISERROR functions in a combination, NB this also works for all error results.

=IF(ISERROR(A1/A2),0,A1/A2)

where A1 and A2 are the respective cell references (substitute your own formula)

 

[haggis]

warburton1,

Your IF and ISERROR solution worked like a charm. All I changed was replacing the 0 with "" to display a blank cell rather than a zero. Now my blank template looks good!

Thanks