comparing formula results with a cell

  • Thread starter Thread starter KimW
  • Start date Start date
K

KimW

How do I compare the formula result in one cell with the text in another
cell? I have a formula calculating a date in cell A1 and want to compare that
to the Month (text) typed in cell A4 and then in Cell A5 return "Goal
Setting" if the comparison is true and "Monthly Feedback" if false.
 
Hi,

Comparing a taext month like Lanuary to a properly formatted date can be
done but is not the place to start from and if it's not too late to change
this text date to a proper date then I would do that. However, this will work

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

Note this compare the full text month January ur February for example. If
you using Jan & Feb change the formula to

=IF(TEXT(A1,"mmm")=A4,"Goal Setting","Monthly feedback")

Mike
 
So, you have a formula that returns date as a number, and want to compare the
month of that date to a text date, correct?

You can create a table with the month and month number like so:

A B
January 1
February 2
etc.

on Sheet2

Then, do =IF(MONTH(A1)=VLOOKUP(A4,Sheet2!A:B,2),"Goal Setting","Monthly
Feedback")
 
This assumes that the text entry in A4 is *not* abbreviated:

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


If it is, reduce the number of "m's" accordingly.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


How do I compare the formula result in one cell with the text in another
cell? I have a formula calculating a date in cell A1 and want to compare
that
to the Month (text) typed in cell A4 and then in Cell A5 return "Goal
Setting" if the comparison is true and "Monthly Feedback" if false.
 
And with my response in your other posting of pretty much the same question,
you have at least 3 ways to get the job done :).
 
Back
Top