what means 'blank cell'??
noup, sorry - it gives a blank cell even when the condition it ok (e.g. above
0.5)
thanks anyway,
Ted.
"Peo Sjoblom" wrote:
How about
=IF(AND(C3-D30,COUNT(C3:D3)=2),IF(ROUND((C3-D3)/7,5)0.5,ROUND((C3-D3)/7,5),""),"")
--
Regards,
Peo Sjoblom
(No private emails please)
"Ted" wrote in message
...
I am trying to calculate the difference between two dates and have that
diveded by seven, (e.g. 7/XX-XX) and remove any answers that sum less than
0.5
So far I have the below formula, but it returns an "ERROR" where there is
blank cells. I think that is because of the zero in the ...C3-D3<0),..
section
=IF(AND(ISNUMBER(C3),ISNUMBER(D3),C3-D3<0),IF(ROUND(7/(C3-D3),5)0.5,ROUND(7/(C3-D3),5),""))
has anyone any ideas please??
Ted.
|