Greater than zero problem
 

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.

Greater than zero problem
 

=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.
|
|

Greater than zero problem
 

=LEN(I3)0

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
"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.