Excel Question "OR" function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
Click to expand...
B1 =IF(OR(A1=H, SD, V),10, A1+A2))
My goal is to get the value 10 to appear in B1 if The
Click to expand...
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.
 
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.
Click to expand...
 
Back
Top