Re: what means 'blank cell'??
- From: Ron Rosenfeld <ronrosenfeld@xxxxxxxxxx>
- Date: Sun, 20 Nov 2005 21:00:34 -0500
On Sun, 20 Nov 2005 17:14:01 -0800, Ted <Ted@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
>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.
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
.
- Prev by Date: Re: Checking for dublication of text
- Next by Date: Re: Checking for dublication of text
- Previous by thread: Struggling for a solution
- Next by thread: Re: help with formula
- Index(es):
Relevant Pages
|
