Comparison Formula
On Sat, 31 Jan 2009 20:56:48 GMT, Lars-Åke Aspelin
wrote:
On Sat, 31 Jan 2009 12:52:34 -0800 (PST), Savio
wrote:
I have a day entered in cell E2, and i am trying to write a formula to
return "T" if E2 is any value from Monday-Friday and "F" if not.
=IF(E2=OR("Monday","Tuesday","Wednesday","Thursd ay","Friday"),"T","F")
Could you tell me what's wrong with the above formula and how to
correct it.
thanks
Try this:
=IF(OR(E2="Monday",E2="Tuesday",E2="Wednesday",E2 ="Thursday",E2="Friday"),"T","F")
Hope this helps / Lars-Åke
A bit shorter:
=IF(OR(E2={"Monday","Tuesday","Wednesday","Thursda y","Friday"}),"T","F")
/ Lars-Åke
|