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




How can I get excel to ignore formula in dependant cells...
Hi, I need to run a formula on cells which themselves contain formula. The
second formula is subtracting, say, A1 from B1. The problem is when there are no answers in the dependant cells (A1, B1 or both) â€“ it, as expected just gives a value of #VALUE! How can I get excel to ignore the formula and return the value of zero, when no data/numbers have been generated by the original/initial formula/dependant cells?? Thanks in advance. Ted. 
Ads 
#2




How can I get excel to ignore formula in dependant cells...
Ted, =IF(ISERROR(sum(B1A1)),0,SUM(B1A1)) Cheers, Steve  SteveG  SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=486988 
#3




How can I get excel to ignore formula in dependant cells...
On Mon, 21 Nov 2005 12:28:04 0800, Ted > wrote:
>Hi, I need to run a formula on cells which themselves contain formula. The >second formula is subtracting, say, A1 from B1. The problem is when there are >no answers in the dependant cells (A1, B1 or both) – it, as expected just >gives a value of #VALUE! > >How can I get excel to ignore the formula and return the value of zero, when >no data/numbers have been generated by the original/initial formula/dependant >cells?? > >Thanks in advance. > >Ted. One thing you can do is to keep your problem in the same thread, so that people won't be wasting time posing solutions that you have tried but have already failed, for one reason or another. ron 
#4




How can I get excel to ignore formula in dependant cells...
sorry, I thought that once more messages had been added, older ones get moved
to other pages, so are less likely to be seen  I tried to repost one a couple of days ago using the " click this link to continue receiving notifications for this thread." thread, but received nothing from it (hence me assuming that once messages are pushed to page two onward they are not seen). Sorry about that  I'll make sure I keep to the original thread, to which you recently replied: URL: http://www.microsoft.com/office/comm...0f2fbd7a0c4c5 Thanks, and sorry about that. Ted. "Ron Rosenfeld" wrote: > On Mon, 21 Nov 2005 12:28:04 0800, Ted > wrote: > > >Hi, I need to run a formula on cells which themselves contain formula. The > >second formula is subtracting, say, A1 from B1. The problem is when there are > >no answers in the dependant cells (A1, B1 or both) â€“ it, as expected just > >gives a value of #VALUE! > > > >How can I get excel to ignore the formula and return the value of zero, when > >no data/numbers have been generated by the original/initial formula/dependant > >cells?? > > > >Thanks in advance. > > > >Ted. > > One thing you can do is to keep your problem in the same thread, so that people > won't be wasting time posing solutions that you have tried but have already > failed, for one reason or another. > > > ron > 
#5




How can I get excel to ignore formula in dependant cells...
Hi Ted
See answer posted to your earlier thread. Regards Roger Govier Ted wrote: > Hi, I need to run a formula on cells which themselves contain formula. The > second formula is subtracting, say, A1 from B1. The problem is when there are > no answers in the dependant cells (A1, B1 or both) â€“ it, as expected just > gives a value of #VALUE! > > How can I get excel to ignore the formula and return the value of zero, when > no data/numbers have been generated by the original/initial formula/dependant > cells?? > > Thanks in advance. > > Ted. > 
Thread Tools  
Display Modes  


Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
quick way to copypaste a formula linked to cells in another file  iniakupake  Excel Worksheet Functions  2  September 26th 05 03:56 AM 
copy & paste spreadsheet cells from excel to outlook to excel  mismarple  Excel Discussion (Misc queries)  1  September 20th 05 11:16 PM 
Ignore error msgs in formula references  gharden  Excel Discussion (Misc queries)  4  June 17th 05 12:14 AM 
How do I ignore cells in Excel?  texanfanrocket  Excel Worksheet Functions  12  June 9th 05 11:23 PM 
Formula checking multiple worksheets  sonicthemouse  Excel Worksheet Functions  2  June 5th 05 07:48 PM 