TRUE/FALSE STATEMENT

  • Thread starter Thread starter Dave
  • Start date Start date
D

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
 
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.
 
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
 
Thats great! Works briliiantly!

Kevin Smith said:
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.
Click to expand...
 
Thanks. This works greatly!

Jacob Skaria said:
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
Click to expand...
 
Back
Top