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.
Bookmarks