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
|
|||
|
|||
#DIV/0!
I've got a YTD spreadsheet that will be fed each month
from monthly spreadsheets... In some of the cells within the monthly spreadsheets it is #DIV/0!... As the data is fed in by the month Division by 0 is elimated, due to the cells in the formula being fed numbers... What I want to know is it possible in the year to date spread, to SUM a row say SUM(A4:F4) with some of the cells containing #DIV/0!?? Thanks kevin |
#2
|
|||
|
|||
Hi
why not prevent the #DIV/0 errors with a fomula such as =IF(N(A1)=0,"",B1/A1) -- Regards Frank Kabel Frankfurt, Germany wrote: I've got a YTD spreadsheet that will be fed each month from monthly spreadsheets... In some of the cells within the monthly spreadsheets it is #DIV/0!... As the data is fed in by the month Division by 0 is elimated, due to the cells in the formula being fed numbers... What I want to know is it possible in the year to date spread, to SUM a row say SUM(A4:F4) with some of the cells containing #DIV/0!?? Thanks kevin |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
DIV/0 | wiredbliss | General Discussion | 2 | August 14th, 2004 09:02 AM |
Find #DIV/0! Error and Replace | Dave Peterson | Worksheet Functions | 5 | January 12th, 2004 06:18 PM |