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

If A1 is actually formatted as a date and not text, then this should work for
you:

=IF(ISNA(MATCH(A4,{"January","February","March","A pril","May","June","July","August","September","Oc tober","November","December"},0)),"MonthlyFeedback ",IF(MONTH(A1)=MATCH(A4,{"January","February","Mar ch","April","May","June","July","August","Septembe r","October","November","December"},0),"Goal
Setting","MonthlyFeedback"))

Change the list of months to "Jan","Feb", etc. if you're using abbreviations
in A4.

The IF(ISNA()) portion of the formula will cause a "Monthly Feedback" entry
to appear if one of the month list entries is not in A4 (as blank, or
misspelled).


"KimW" wrote:

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

If the month in A4 is text as in October and the result in A1 is for
instance 10/28/2009 than you can use

=IF(TEXT(A1,"mmmm")=A4,"Goal Setting","Monthly Feedback")

--


Regards,


Peo Sjoblom


"KimW" wrote in message
...
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