- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel
- 2009 March
- Formulas Divided by 0 =#Div/0!

Subject: | Formulas Divided by 0 =#Div/0! |

Posted by: | Chad Cameron (chadNOT483@hotmail.com remove NOT) |

Date: | Fri, 13 Mar 2009 |

I usually come across this problem, and I fix it with a simple if statement.

But today, I have received a huge spreadsheet and this problem is all over

the place, at least 100 entries. Cut and paste the modifed formula with an

if statement will not work.

Is there an easier way to show a 0 or blank in this cells instead of #Div/0!

Thanks

Chad

- Re: Formulas Divided by 0 =#Div/0! posted by Dave Peterson on Fri, 13 Mar 2009
- Re: Formulas Divided by 0 =#Div/0! posted by chrâ€¦@spreadsheet-converter.com on Sat, 14 Mar 2009