show as blank errors #value! and -42369

[shtuamouth]

hello.
I am using a simple formula to calculate days between 2 dates in cell A1 and A2 to return days in A3 by using =A1-A2.

When i autofill the A column there are 2 errors i get in empty cells. #value! and -42369.

I managed to sort out the #value! error by using =IFERROR(A1-A2), 0)

But cannot find a way to show -42369 as blank. Is there any custom format which can be used like 0;-0;;@ to remove zeros for instance

[Tony Valko]

Try this...

0;[<0]"";;@

The cell will still have a negative value, you just won't see it.

[shtuamouth]

thx a bunch it worked. One more thing if you cn help me with it.

I have empty cells showing - which i want it to show as blank. The other cells display numbers. I tried 0;[<0]"";;@ and it works but the cells with numbers don't display the seperator(,) and decimal places like before. can you help with that

[Tony Valko]

Instead of using formatting why not just do this in the formula?

If the result of A1-A2 is less than or equal to 0 or an error the formula will return blank.

=IFERROR(IF(A1-A2<=0,"",A1-A2),"")