TRUE/FALSE STATEMENT
 

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

TRUE/FALSE STATEMENT
 

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.
--
Kevin Smith :o)


"Dave" wrote:

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

TRUE/FALSE STATEMENT
 

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
---------------
Jacob Skaria


"Dave" wrote:

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

TRUE/FALSE STATEMENT
 

Thats great! Works briliiantly!

"Kevin Smith" wrote:

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.
--
Kevin Smith :o)


"Dave" wrote:

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

TRUE/FALSE STATEMENT
 

Thanks. This works greatly!

"Jacob Skaria" wrote:

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
---------------
Jacob Skaria


"Dave" wrote:

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