Replace with "O' if #Div/0I

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.
 
Back
Top