Compare formula result with text
- From: KimW <KimW@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 29 Oct 2009 08:01:02 -0700
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
.
- Follow-Ups:
- Re: Compare formula result with text
- From: Peo Sjoblom
- RE: Compare formula result with text
- From: JLatham
- Re: Compare formula result with text
- Prev by Date: Loosing formatting in 2007
- Next by Date: Automatic Email Rota from Excel (2007)
- Previous by thread: Loosing formatting in 2007
- Next by thread: RE: Compare formula result with text
- Index(es):
Relevant Pages
|