Reply to thread

Message

<blockquote data-quote="blackbonnie" data-source="post: 3341443" data-attributes="member: 573596"><p>here is my problem, its not a big problem but it kinda pisses me off. i am creating a spreadsheet, and like most you have to enter values and another box will solve the equation. well i have some equations that are division. and when the values are empty, the answer box will say &quot;#DIV/0&quot; . now i have been searching through excel and there help and everything for my answer. now all i want to do is not have it say &quot;#DIV/0&quot; thats all i want. i know that i am trying to divide an equation by 0 and blah blah, but i just dont want it to display &quot;#DIV/0&quot; . so if anyone has any help on how to make it not display that, but still have the equation there. i would be happy if it just displayed 0 like all the other cells. i am using excel 2007, but im sure if you can solve it in an earlier version it would still be the same. any help is greatly appreciated. again its not a huge problem its just that i like to be organzied and i think that makes it look un-proffesional.</p></blockquote><p></p>

[QUOTE="blackbonnie, post: 3341443, member: 573596"] here is my problem, its not a big problem but it kinda pisses me off. i am creating a spreadsheet, and like most you have to enter values and another box will solve the equation. well i have some equations that are division. and when the values are empty, the answer box will say "#DIV/0" . now i have been searching through excel and there help and everything for my answer. now all i want to do is not have it say "#DIV/0" thats all i want. i know that i am trying to divide an equation by 0 and blah blah, but i just dont want it to display "#DIV/0" . so if anyone has any help on how to make it not display that, but still have the equation there. i would be happy if it just displayed 0 like all the other cells. i am using excel 2007, but im sure if you can solve it in an earlier version it would still be the same. any help is greatly appreciated. again its not a huge problem its just that i like to be organzied and i think that makes it look un-proffesional. [/QUOTE]

Verification