| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| TRUE/FALSE function in IF statement | Excel Worksheet Functions | |||
| Two TRUE to one FALSE statement | Excel Worksheet Functions | |||
| If Statement returns true when false? | Excel Discussion (Misc queries) | |||
| Want to change the color of a true/false logical statement with i. | Excel Worksheet Functions | |||
| How can I make a True or False statement a certain color when usi. | Excel Worksheet Functions | |||
Hybrid Mode
