I cant work out what the error is.

  • Thread starter Thread starter ss
  • Start date Start date
S

ss

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
 
Either C11 or D11 has a #VALUE in it.
Click to expand...
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.
 
Back
Top