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 » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Problem solving div/0 error in a zero value cell



 
 
Thread Tools Display Modes
  #1  
Old March 17th, 2006, 03:13 AM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: n/a
Default Problem solving div/0 error in a zero value cell


I need a fix for a problem I am having .I have a qoute sheet linked to a
spread sheet with multiple rows of Items bein qouted, when I have data
in the cells everything is dandy,but if I have nothing in the cell for
instance I only use one line on the qoute sheet instead of two or eight
I get a div/o error that stops my totals calculations on the first page
and then transfers it to my customer copy.
origanlcode
(G7+I7*G3)+(H7*I3)/F7
Fix hides error code
=IF(ISERROR((G7+I7*G3)+(H7*I3)/F7),"",(G7+I7*G3)+(H7*I3)/F7)
the dividing by zero I understand because there is no numbers in the
code when not in use ,but I cant seem to come up with a different way
of coding it.The if error fix makes it disapear but I still cant total
my numbers unless all rows have data ,any Ideas?

Thanks
Bob S.


--
robert s
------------------------------------------------------------------------
robert s's Profile: http://www.excelforum.com/member.php...o&userid=32207
View this thread: http://www.excelforum.com/showthread...hreadid=523396

  #2  
Old March 17th, 2006, 03:49 AM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: n/a
Default Problem solving div/0 error in a zero value cell

First of all, try this for your original formula (little shorter):

=IF(F70,(G7+I7*G3)+(H7*I3)/F7,"")

Then, since you say you're not able to total the cells that contain this
formula, I'm guessing that you're *not* using the SUM() function to total
your sheet, but probably using pluses (+) instead (=A1+A2+A3+A4)

Try using SUM()
=SUM(A1:A4)
OR
=SUM(A1,B2,C3,D4)

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



"robert s" wrote in
message ...

I need a fix for a problem I am having .I have a qoute sheet linked to a
spread sheet with multiple rows of Items bein qouted, when I have data
in the cells everything is dandy,but if I have nothing in the cell for
instance I only use one line on the qoute sheet instead of two or eight
I get a div/o error that stops my totals calculations on the first page
and then transfers it to my customer copy.
origanlcode
(G7+I7*G3)+(H7*I3)/F7
Fix hides error code
=IF(ISERROR((G7+I7*G3)+(H7*I3)/F7),"",(G7+I7*G3)+(H7*I3)/F7)
the dividing by zero I understand because there is no numbers in the
code when not in use ,but I cant seem to come up with a different way
of coding it.The if error fix makes it disapear but I still cant total
my numbers unless all rows have data ,any Ideas?

Thanks
Bob S.


--
robert s
------------------------------------------------------------------------
robert s's Profile:

http://www.excelforum.com/member.php...o&userid=32207
View this thread: http://www.excelforum.com/showthread...hreadid=523396


  #3  
Old March 17th, 2006, 03:55 AM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: n/a
Default Problem solving div/0 error in a zero value cell

Maybe replace the null "" in your formula with a zero 0......, or 1, or
..00000001.....

hth
Vaya con Dios,
Chuck, CABGx3



"robert s" wrote in
message ...

I need a fix for a problem I am having .I have a qoute sheet linked to a
spread sheet with multiple rows of Items bein qouted, when I have data
in the cells everything is dandy,but if I have nothing in the cell for
instance I only use one line on the qoute sheet instead of two or eight
I get a div/o error that stops my totals calculations on the first page
and then transfers it to my customer copy.
origanlcode
(G7+I7*G3)+(H7*I3)/F7
Fix hides error code
=IF(ISERROR((G7+I7*G3)+(H7*I3)/F7),"",(G7+I7*G3)+(H7*I3)/F7)
the dividing by zero I understand because there is no numbers in the
code when not in use ,but I cant seem to come up with a different way
of coding it.The if error fix makes it disapear but I still cant total
my numbers unless all rows have data ,any Ideas?

Thanks
Bob S.


--
robert s
------------------------------------------------------------------------
robert s's Profile:

http://www.excelforum.com/member.php...o&userid=32207
View this thread: http://www.excelforum.com/showthread...hreadid=523396



  #4  
Old March 17th, 2006, 04:01 AM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: n/a
Default Problem solving div/0 error in a zero value cell

If setting the result to blank when you divide by zero still causes problems,
then you need to set it to something else that won't. What about setting it to
zero rather than blank? Does that work?

Also, you can simplify your If statement by testing only F7 as follows:

=if(f7=0,0,G7+I7*G3+(H7*I3)/F7)

--
Regards,
Fred


"robert s" wrote in
message ...

I need a fix for a problem I am having .I have a qoute sheet linked to a
spread sheet with multiple rows of Items bein qouted, when I have data
in the cells everything is dandy,but if I have nothing in the cell for
instance I only use one line on the qoute sheet instead of two or eight
I get a div/o error that stops my totals calculations on the first page
and then transfers it to my customer copy.
origanlcode
(G7+I7*G3)+(H7*I3)/F7
Fix hides error code
=IF(ISERROR((G7+I7*G3)+(H7*I3)/F7),"",(G7+I7*G3)+(H7*I3)/F7)
the dividing by zero I understand because there is no numbers in the
code when not in use ,but I cant seem to come up with a different way
of coding it.The if error fix makes it disapear but I still cant total
my numbers unless all rows have data ,any Ideas?

Thanks
Bob S.


--
robert s
------------------------------------------------------------------------
robert s's Profile:
http://www.excelforum.com/member.php...o&userid=32207
View this thread: http://www.excelforum.com/showthread...hreadid=523396



  #5  
Old March 18th, 2006, 05:45 PM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: n/a
Default Problem solving div/0 error in a zero value cell


Thanks for the help you saved me many hours of trying different fixes .
RagDyer your fix worked great,I had to apply the fix to the totals
column too
and format the cells to general before it worked but it does and thanks
alot.


Bob S.


--
robert s
------------------------------------------------------------------------
robert s's Profile: http://www.excelforum.com/member.php...o&userid=32207
View this thread: http://www.excelforum.com/showthread...hreadid=523396

  #6  
Old March 18th, 2006, 11:33 PM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: n/a
Default Problem solving div/0 error in a zero value cell

Appreciate the feed-back.
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

"robert s" wrote in
message ...

Thanks for the help you saved me many hours of trying different fixes .
RagDyer your fix worked great,I had to apply the fix to the totals
column too
and format the cells to general before it worked but it does and thanks
alot.


Bob S.


--
robert s
------------------------------------------------------------------------
robert s's Profile:
http://www.excelforum.com/member.php...o&userid=32207
View this thread: http://www.excelforum.com/showthread...hreadid=523396


 




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
Urgent date/scheduling calc needed jct Worksheet Functions 3 February 24th, 2006 02:36 AM
Hyperlink problem to cell in same workbook stainless General Discussion 1 November 15th, 2005 05:53 PM
formula problem. Find if a formula has entered data into a cell con_tg Worksheet Functions 2 August 28th, 2004 10:51 AM
IF E3 & E10 = TRUE set this cell to "Yes", else set to "No" Timothy L Worksheet Functions 5 August 27th, 2004 02:28 AM
Do you have what it takes... darno Worksheet Functions 0 February 22nd, 2004 09:01 PM


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


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