Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 20th 05, 10:35 PM
Joohn Calder
 
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   Report Post  
Old September 20th 05, 10:37 PM
Bob Phillips
 
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





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Div/0 error scott45 Excel Worksheet Functions 4 September 9th 05 04:21 PM
Can I prevent a #DIV/0! error from plotting on a chart CTarantino Charts and Charting in Excel 3 August 26th 05 08:35 AM
DIV/0! error in SumProduct formula with no division Irrational Excel Worksheet Functions 1 August 18th 05 01:39 AM
# DIV/0! error in Excel Helpwanted Excel Discussion (Misc queries) 8 May 6th 05 09:31 PM
"Average" with error DIV/0 agenda9533 Excel Discussion (Misc queries) 1 March 2nd 05 06:47 PM


All times are GMT +1. The time now is 07:16 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017