| Home |
| Search |
| Today's Posts |
|
#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 |
| 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 | |||
Threaded Mode
