MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Hiding the formula in Excel


Posted by David Snedeker on August 27, 2001 6:41 PM

I have designed a very simple spreadsheet that will tell me how many reservations to calls my reps have taken.

The formula is =SUM(C5/C4) and so on down the row. I am getting the message #DIV/0! which I know indicates that I am dividing by a divisor of 0 I think or something like that. I am fine with that. I just need to kow how to hide what that shows because I will be placing numbers in the 2 cells before it to properly let it divide. But in the meantime it will be 0. How do I hide #DIV/0!


Thanks
David


Posted by anno on August 27, 2001 7:56 PM

hi david
i think this will work:
=IF(C5,IF(C4,(SUM(C5/C4))),0)
also i may have missed something, but wouldn't it work just as well without the sum function, like this:
=IF(C5,IF(C4,(C5/C4)),0) )

Posted by Ian on August 28, 2001 3:39 AM

=IF(iserr(C5/C4) ,"",C5/C4)

Posted by Mark W. on August 28, 2001 6:59 AM

Even simplier...

You need only test the denominator as follows...

=IF(C4,C5/C4,"")

Posted by anno on August 28, 2001 4:13 PM

Re: Even simplier...

=IF(C4,C5/C4,"")

aha! took me a minute to see why your simplification works, but of course! - it's the denominator that causes the #div/0!. another valuable lesson. i bow before your knowledge, o excel addict.