TRUE/FALSE STATEMENT

[Dave]

Hi,

lI have a formula that returns a TRUE or False statement. If the statement
is TRUE I want the cell to show the TITLE of the column. How do i do this.
The current formula is:

=((TODAY()-WEEKDAY(TODAY(),2))<$A2)

Thanks

 

[Kevin Smith]

Hello,

if you do ...
=IF(((TODAY()-WEEKDAY(TODAY(),2))<$A2),$A$1,"")

If this is true you return the info in cell A1 otherwise it returns nothing.

 

[Jacob Skaria]

I am not sure I have understood you correctly...TITLE means the header cell
or what?

=IF(your formula,if true,if false)

=IF(TODAY()-WEEKDAY(TODAY(),2)<$A2,$A$1)

If this post helps click Yes

 

[Dave]

Thats great! Works briliiantly!

Hello,

if you do ...
=IF(((TODAY()-WEEKDAY(TODAY(),2))<$A2),$A$1,"")

If this is true you return the info in cell A1 otherwise it returns nothing.

 

[Dave]

Thanks. This works greatly!

I am not sure I have understood you correctly...TITLE means the header cell
or what?

=IF(your formula,if true,if false)

=IF(TODAY()-WEEKDAY(TODAY(),2)<$A2,$A$1)

If this post helps click Yes