Excel 97 - #Div/0! Error Message - how do I get rid of it?

[dsmith910]

Hi

I've inherited a set of spreadsheets which run on Excel 97. On one of them I get the above error message where the cell formula is say =J5/J21*E62 and one of those cells is equal to '0'. Any idea how to get rid of the error message and replace it say with a '0'? At the moment the previous owner of this sheet entered 0.01 in the empty cell to remove the error message - but I kind of like things to add up properly!

Thanks

Doreen

PS I'm sure I saw the answer on the formum somewhere while I was browsing through the information on here - but I failed to keep a copy and now I can't find it. Sorry if you've already answered this for someone else!

 

[xlbo]

Just test to see if the divisor is 0:
=if(J21=0,0,J5/J21*E62)

Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde

 

[dsmith910]

Hi Geoff

You've just made my day! .... again.

Thanks

Doreen