Excel treats cells with a formula returning nothing as zero value.

Is the formula cell formatted as Date and you get 1/0/00?

What do you see when you format to General or Number?


Gord Dibben MS Excel MVP

On Wed, 22 Apr 2009 11:39:04 -0700, TWP
wrote:

My formula reads as follows
=INDEX('Agency Relief'!$B$2:$AG$103, MATCH($B34,'Agency
Relief'!$B$2:$B$103), MATCH($C2,'Agency Relief'!$B$2:$AG$2))
In the cell it is giving me a date when I know it should be blank. When
there is an answer it does put it there but I don't want these dates in the
cell when it is supposed to be blank...Please help