Formula - Day of the week match

[falcios]

Hello:

I have the following days of the week in column A:
Tuesday
Wednesday
Friday
Saturday

Is there a formula I can use so that if it is Tuesday or Friday, then the number 5 is entered in the same row but in column B? Also, if it is Wednesday or Saturday the number 3 is entered in column B. If possible without VBA.

Thanks in advance.

 

[Phuoc]

Try this:

=IF(OR(A2={"Tuesday","Friday"}),5,IF(OR(A2={"Wednesday","Saturday"}),3,""))

 

[falcios]

=IF(OR(A2={"Tuesday","Friday"}),5,IF(OR(A2={"Wednesday","Saturday"}),3,""))

Thanks Phuoc it worked great.