MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel If condition


Posted by Mike Stasins on February 15, 2002 6:49 AM

Hello,

How would I go about having the condition test for a certain text value in a cell and if it was tru copy values from one cell to another.
Example:
if b14 = "February"
c10 = b10;
Please let me know how I can get that condition to work
Thank you,


Posted by Aladin Akyurek on February 15, 2002 7:00 AM

What is exactly in B4 -- a date or a month name?

If B4 holds a date, use:

=IF(TEXT(B4,"mmmm")="February",b10,"?")

entered in C10;

If B4 holds a month name, use:

=IF(B4="February",b10,"?")

entered in C10.

You didn't tell what to do when the condition does not hold, whence "?".

===============