Help with #VALUE! error please...
On Mon, 21 Nov 2005 13:02:01 -0800, Ted wrote:
Hi Ron, its:
=IF(AND(C4-D40,COUNT(C4:D4)=2),IF(ROUND(7/(C4-D4),5)0.5,ROUND(7/(C4-D4),5),""),"")
So this formula is in Sheet1!C23 and also in Sheet2!C23
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)
in Sheet2!E43 /
the first cell is on 'Sheet 2' and the second on 'Sheet 1'
Any ideas please??
1. Change the formulas in Sheet1!C23 and Sheet2!C23 to:
=IF(AND(C4<D4,COUNT(C4:D4)=2),IF(ROUND(7/(C4-D4),5)0.5,ROUND(7/(C4-D4),5),""),"")
2. Change your SUM formula in E43 to:
=IF(COUNT(Sheet2:Sheet1!C23)=2,SUM(Sheet2:Sheet1!C 23),0)
--ron
|