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 "?".
===============
