| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compare formula result with text
How do I compare the results of a formula with the text in another field?
Example: I have a formula that is calculating a date (mm/dd/yyyy) in cell A1. I want to compare that to the Month (text) in cell A4 and in cell A5 return "Goal Setting" if the result is TRUE and "Monthly Feedback" if the result is FALSE |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need result of formula to compare itself to another number andincrease if needed. | Excel Discussion (Misc queries) | |||
| copy formula result (text) only - without copying formula | Excel Discussion (Misc queries) | |||
| Text Result Formula | Excel Discussion (Misc queries) | |||
| what if the result of a formula is text | Excel Worksheet Functions | |||
| formula is displayed as literal text instead of formula result | Excel Discussion (Misc queries) | |||
Threaded Mode
