R
robert s
I need a fix for a problem I am having .I have a qoute sheet linked to
spread sheet with multiple rows of Items bein qouted, when I have dat
in the cells everything is dandy,but if I have nothing in the cell fo
instance I only use one line on the qoute sheet instead of two or eigh
I get a div/o error that stops my totals calculations on the first pag
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 th
code when not in use ,but I cant seem to come up with a different wa
of coding it.The if error fix makes it disapear but I still cant tota
my numbers unless all rows have data ,any Ideas?
Thanks
Bob S
spread sheet with multiple rows of Items bein qouted, when I have dat
in the cells everything is dandy,but if I have nothing in the cell fo
instance I only use one line on the qoute sheet instead of two or eigh
I get a div/o error that stops my totals calculations on the first pag
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 th
code when not in use ,but I cant seem to come up with a different wa
of coding it.The if error fix makes it disapear but I still cant tota
my numbers unless all rows have data ,any Ideas?
Thanks
Bob S