MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel If condition

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


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.
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:


entered in C10;

If B4 holds a month name, use:


entered in C10.

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