Thread: if statement
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Debra Reid Debra Reid is offline
external usenet poster
 
Posts: 3
Default if statement

Thanks this helps.

"Jacob Skaria" wrote:

Text strings should be within quotes...

=IF(OR(A1="v",A1="m"),"Yes","No")

--
Jacob


"Debra Reid" wrote:

In using the "if" statement I would like the logic portion to state that if
cell# = v or m or d or a but the if statement seems to only work if the logic
is = to a number. Should I be using another formula?