hi, thanks for that - yep that works great $;-D

thanks, Ted.


"Peo Sjoblom" wrote:

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

--
Regards,

Peo Sjoblom

(No private emails please)


"Peo Sjoblom" wrote in message
...
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.