A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

#DIV/0! Error



 
 
Thread Tools Display Modes
  #1  
Old September 20th, 2005, 10:35 PM
Joohn Calder
external usenet poster
 
Posts: n/a
Default #DIV/0! Error

Hi

I get an error (#DIV/0!) when I divide one cell by the other and there are
no entries in the cells.

How can i get the folrmula to surpress the error (show a blank cell) when
there are no entries in the cells that the formula refers to?

Could you please provide an example

Thanks

John
  #2  
Old September 20th, 2005, 10:37 PM
Bob Phillips
external usenet poster
 
Posts: n/a
Default

=IF(B1=0,"",A1/B1)

--
HTH

Bob Phillips

"Joohn Calder" wrote in message
...
Hi

I get an error (#DIV/0!) when I divide one cell by the other and there are
no entries in the cells.

How can i get the folrmula to surpress the error (show a blank cell) when
there are no entries in the cells that the formula refers to?

Could you please provide an example

Thanks

John



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Can I prevent a #DIV/0! error from plotting on a chart curious Charts and Charting 1 August 26th, 2005 08:35 AM
Help! I'm getting error messages too much-can't open Resume Wizard LizLB General Discussion 0 May 3rd, 2005 01:46 AM
Help, i'm gettiing error: Access has encountered a problem and needs to close... betsy General Discussion 0 September 14th, 2004 08:20 PM
INSERT query inside an error handler? Richard Hollenbeck Running & Setting Up Queries 7 September 11th, 2004 02:31 PM
Productkey problem when installing office 2003 on network Stefan Schreurs Setup, Installing & Configuration 1 June 1st, 2004 11:16 PM


All times are GMT +1. The time now is 05:22 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.