In this formula =IF(D12=0,"",D12 -C12+1) I get a return of 28 which
is correct.

In this formula =IF(D11=0,"",D11 -C11+1) I get #VALUE!

I cant understand this, I have checked cell format and both are in
general, I have tried dragging down and still no change. The subtraction
elemenst are 2 dates.

You'll see this error if
D11 is non-empty and non-numeric
or
C11 is non-empty and non-numeric





On 02/06/2012 06:01, ss wrote:
> In this formula =IF(D12=0,"",D12 -C12+1) I get a return of 28 which is correct.
>
> In this formula =IF(D11=0,"",D11 -C11+1) I get #VALUE!
>
> I cant understand this, I have checked cell format and both are in general, I
> have tried dragging down and still no change. The subtraction elemenst are 2 dates.
>

--
Dave Peterson

On Mon, 06 Feb 2012 12:01:47 +0000, ss wrote:
> In this formula =IF(D11=0,"",D11 -C11+1) I get #VALUE!

Either C11 or D11 has a #VALUE in it.



--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
Shikata ga nai...

On 07/02/2012 00:20, Stan Brown wrote:
> On Mon, 06 Feb 2012 12:01:47 +0000, ss wrote:
>> In this formula =IF(D11=0,"",D11 -C11+1) I get #VALUE!
>
> Either C11 or D11 has a #VALUE in it.
>
>
>
Now sorted I dragged down the cells above (same format) and it sorted
the problem although I still never worked out what the prob was.