SOLVED

How to write an If function to check 3 different values?

Copper Contributor
=IF(C3="Monday",(I3-D3),I3). This is ok for the case Monday.What I have to fill or edit it in case of Wednesday and Friday in addition to Monday in the same formula.Please suggest.
Thanking you.
4 Replies
best response confirmed by Hanuman_Bandreddi (Copper Contributor)
Solution

@Hanuman_Bandreddi 

Perhaps like this:

=IF(OR(C3="Monday",C3="Wednesday",C3="Friday"),I3-D3,I3)

 

Thank you for your quick reply sir.

@Hanuman_Bandreddi 

As variant

=IF(XOR(C3={"Monday","Wednesday","Friday"}),I3-D3,I3)
1 best response

Accepted Solutions
best response confirmed by Hanuman_Bandreddi (Copper Contributor)
Solution

@Hanuman_Bandreddi 

Perhaps like this:

=IF(OR(C3="Monday",C3="Wednesday",C3="Friday"),I3-D3,I3)

 

View solution in original post