Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
Hyperlink problem to cell in same workbook | Excel Discussion (Misc queries) | |||
Excel 2003 Word Wrap Problem within cell | Excel Discussion (Misc queries) | |||
Copy an Drag cell Formula Problem | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions |