View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Inbar
 
Posts: n/a
Default use the OR function inside an IF function

Hi,

I am trying to use the OR function within an IF condition.
when I use each function seperatly, it works fine. but both functions
together always return the value of "B" - as false result, even when the
requested cell holds one of the true values.

for example:
=IF(B18=OR(148,150),"A","B")