Replace with "O' if #Div/0I

A

aasreds

Joined
Jun 23, 2005
Messages
1
Reaction score
0
I am setting up a spreadsheet to calculate some figures for me and would like to set up the last column to display the results. Several of my column are added together and the results then divided by a value (not yet entered in the spreadsheet) resulting in the #Div/0! error. How do I get the column to display "0" for the Div/)! error.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with VBScript/Access database 0
#DIV error 5
Will "IF THEN" Formula accomplish this for me? 3
divide by zero error 4
#DIV/O! 5
Summing only cells that have data and ignoring cells that have#DIV/0! in them 1
Producing empty cell rather than #DIV/0! 9
#DIV/O! Errror with Absolute Number Calculation 7

Back
Top