Help with #VALUE! error please...
Hi Ron, its:
=IF(AND(C4-D40,COUNT(C4:D4)=2),IF(ROUND(7/(C4-D4),5)0.5,ROUND(7/(C4-D4),5),""),"")
quite a handfull I'm afraid. the actual cell reference for where the formula
result is to display is E43
the currnet formula is:
=SUM(C23-Sheet1!C23)
the first cell is on 'Sheet 2' and the second on 'Sheet 1'
Any ideas please??
Ted.
"Ron Rosenfeld" wrote:
On Mon, 21 Nov 2005 12:09:06 -0800, Ted wrote:
hi, no - they contain formula, sorry.
Ah -- that makes a big difference. What is the formula?
Is there a way of gettign it to ignore
the formula and return a zero when there are no numbers in the cell - it
displays the answer to a previous formula.
Post the formulas from A1 & B1.
What was the problem with the formula I suggested?
One method of outputting a zero unless A1 and B1 BOTH contain numbers is:
=IF(COUNT(A1:B1)=2,A1-B1,0)
--ron
|