View Single Post
  #3   Report Post  
Max
 
Posts: n/a
Default

Yes, an example perhaps?

Put in C1: =IF(OR(A1=1,B1=2),"Yes","No")

If either A1 contains a "1" or B1 contains a "2"
(or if both conditions are true)
then C1 will return "Yes", otherwise C1 returns "No"

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
Bompi wrote
is it possible to use a kind [corrected]
of "OR" function into a "IF" function...