use the OR function inside an IF function
=IF(OR(B18=148,B18=150),"A","B")
"Inbar" wrote:
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")
|