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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Urgent date/scheduling calc needed | jct | Worksheet Functions | 3 | February 24th, 2006 01:36 AM |
Hyperlink problem to cell in same workbook | stainless | General Discussion | 1 | November 15th, 2005 04: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 08:01 PM |