Excel Question "OR" function

[Kyle]

I am attempting to use the following statement into cell B1 =IF(OR(A1=H, SD, V),10, A1+A2)
My goal is to get the value 10 to appear in B1 if The either of the letters H, SD, or V are typed in B1. If nothing is typed in B1 I would like to return the value of the calculation A1+A2. I assume this is possible but have not had success.

 

[Charlie]

Try =IF(OR(A1="H",A1="SD",A1="V"),10,A1+A2)

Charlie O'Neill

-----Original Message-----
I am attempting to use the following statement into cell

B1 =IF(OR(A1=H, SD, V),10, A1+A2))

My goal is to get the value 10 to appear in B1 if The

either of the letters H, SD, or V are typed in B1. If
nothing is typed in B1 I would like to return the value of
the calculation A1+A2. I assume this is possible but have
not had success.

 

[Dave Peterson]

One more:

=IF(OR(A1={"H","SD","V"}),10,A1+A2)

I am attempting to use the following statement into cell B1 =IF(OR(A1=H, SD, V),10, A1+A2))
My goal is to get the value 10 to appear in B1 if The either of the letters H, SD, or V are typed in B1. If nothing is typed in B1 I would like to return the value of the calculation A1+A2. I assume this is possible but have not had success.