View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld
 
Posts: n/a
Default 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