=NOT(I3="")

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Patrick Simonds" wrote in message ...
|I need a formula which returns True if the referenced cell has a value and
| false if it does not.
|
| I tried =If(I30,True,False). The problem is that cell I3 contains a
| formula =IF(I3="",IF(WEEKDAY($A$1)=4,$A$1,""),I3+1) which either returns a
| value to the cell if the condition is met, or leaves the cell blank if the
| condition is not met. The reference I3 is used just for this example. It
| could actually be one of 46 cells.
|
|