S
Savio
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","Thursday","Friday"),"T","F")
Could you tell me what's wrong with the above formula and how to
correct it.
thanks
return "T" if E2 is any value from Monday-Friday and "F" if not.
=IF(E2=OR("Monday","Tuesday","Wednesday","Thursday","Friday"),"T","F")
Could you tell me what's wrong with the above formula and how to
correct it.
thanks