software

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),quot;quot;,(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: www.excelforum.com/member.php...oamp;userid=32207
View this thread: www.excelforum.com/showthread...hreadid=523396First of all, try this for your original formula (little shorter):

=IF(F7gt;0,(G7 I7*G3) (H7*I3)/F7,quot;quot;)

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!
==============================================
quot;robert squot; gt; wrote in
message ...
gt;
gt; I need a fix for a problem I am having .I have a qoute sheet linked to a
gt; spread sheet with multiple rows of Items bein qouted, when I have data
gt; in the cells everything is dandy,but if I have nothing in the cell for
gt; instance I only use one line on the qoute sheet instead of two or eight
gt; I get a div/o error that stops my totals calculations on the first page
gt; and then transfers it to my customer copy.
gt; origanlcode
gt; (G7 I7*G3) (H7*I3)/F7
gt; Fix hides error code
gt; =IF(ISERROR((G7 I7*G3) (H7*I3)/F7),quot;quot;,(G7 I7*G3) (H7*I3)/F7)
gt; the dividing by zero I understand because there is no numbers in the
gt; code when not in use ,but I cant seem to come up with a different way
gt; of coding it.The if error fix makes it disapear but I still cant total
gt; my numbers unless all rows have data ,any Ideas?
gt;
gt; Thanks
gt; Bob S.
gt;
gt;
gt; --
gt; robert s
gt; ------------------------------------------------------------------------
gt; robert s's Profile:
www.excelforum.com/member.php...oamp;userid=32207
gt; View this thread: www.excelforum.com/showthread...hreadid=523396
gt;Maybe replace the null quot;quot; in your formula with a zero 0......, or 1, or
..00000001.....

hth
Vaya con Dios,
Chuck, CABGx3
quot;robert squot; gt; wrote in
message ...
gt;
gt; I need a fix for a problem I am having .I have a qoute sheet linked to a
gt; spread sheet with multiple rows of Items bein qouted, when I have data
gt; in the cells everything is dandy,but if I have nothing in the cell for
gt; instance I only use one line on the qoute sheet instead of two or eight
gt; I get a div/o error that stops my totals calculations on the first page
gt; and then transfers it to my customer copy.
gt; origanlcode
gt; (G7 I7*G3) (H7*I3)/F7
gt; Fix hides error code
gt; =IF(ISERROR((G7 I7*G3) (H7*I3)/F7),quot;quot;,(G7 I7*G3) (H7*I3)/F7)
gt; the dividing by zero I understand because there is no numbers in the
gt; code when not in use ,but I cant seem to come up with a different way
gt; of coding it.The if error fix makes it disapear but I still cant total
gt; my numbers unless all rows have data ,any Ideas?
gt;
gt; Thanks
gt; Bob S.
gt;
gt;
gt; --
gt; robert s
gt; ------------------------------------------------------------------------
gt; robert s's Profile:
www.excelforum.com/member.php...oamp;userid=32207
gt; View this thread: www.excelforum.com/showthread...hreadid=523396
gt;
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,
Fredquot;robert squot; gt; wrote in
message ...
gt;
gt; I need a fix for a problem I am having .I have a qoute sheet linked to a
gt; spread sheet with multiple rows of Items bein qouted, when I have data
gt; in the cells everything is dandy,but if I have nothing in the cell for
gt; instance I only use one line on the qoute sheet instead of two or eight
gt; I get a div/o error that stops my totals calculations on the first page
gt; and then transfers it to my customer copy.
gt; origanlcode
gt; (G7 I7*G3) (H7*I3)/F7
gt; Fix hides error code
gt; =IF(ISERROR((G7 I7*G3) (H7*I3)/F7),quot;quot;,(G7 I7*G3) (H7*I3)/F7)
gt; the dividing by zero I understand because there is no numbers in the
gt; code when not in use ,but I cant seem to come up with a different way
gt; of coding it.The if error fix makes it disapear but I still cant total
gt; my numbers unless all rows have data ,any Ideas?
gt;
gt; Thanks
gt; Bob S.
gt;
gt;
gt; --
gt; robert s
gt; ------------------------------------------------------------------------
gt; robert s's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32207
gt; View this thread: www.excelforum.com/showthread...hreadid=523396
gt;

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: www.excelforum.com/member.php...oamp;userid=32207
View this thread: www.excelforum.com/showthread...hreadid=523396Appreciate the feed-back.
--

Regards,

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

quot;robert squot; gt; 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:
www.excelforum.com/member.php...oamp;userid=32207
View this thread: www.excelforum.com/showthread...hreadid=523396