What type of info is in the formula bar?

Maybe a formula that returns blank if a condition is not met?

=IF(A1<12,"",A1) would look blank if A1 was not 12

Or possibly the cells have been custom formatted with 3 semi-colons ;;;
which will leave cells looking blank.


Gord Dibben MS Excel MVP

On Tue, 19 May 2009 11:39:05 -0700, Jennifer
wrote:

Why do the cells in Excel sometimes appear blank but in the function line it
shows that it has info in it?