what means 'blank cell'??

T

Ted

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.
 
P

Peo Sjoblom

How about

=IF(AND(C3-D3>0,COUNT(C3:D3)=2),IF(ROUND((C3-D3)/7,5)>0.5,ROUND((C3-D3)/7,5),""),"")

--
Regards,

Peo Sjoblom

(No private emails please)
 
R

Ron Rosenfeld

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.
Click to expand...

See my response (2nd suggestion) in your other thread. It does not return an
error if both cells are blank.

It is much easier to obtain coherent help if you keep all your related
questions in the same thread.




--ron
 
P

Peo Sjoblom

..
Oops! reverse the division, I just assumed it was a typo

--
Regards,

Peo Sjoblom

(No private emails please)
 
T

Ted

noup, sorry - it gives a blank cell even when the condition it ok (e.g. above
0.5)

thanks anyway,

Ted.
 
Top