is it possible to use a cind of "OR" function into a "IF" function...
is it possible to use a cind of "OR" function into a "IF" function...
Yes for example the function below will put the word "TRUE" into the cell
where you put this function if the cell A1 has "Y" or "YES" in it.
=IF(OR(A1="Y",A1="YES"),"TRUE","FALSE")
"Bompi" wrote:
> is it possible to use a cind of "OR" function into a "IF" function...
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 <at>yahoo<dot>com
----
Bompi <[email protected]> wrote
> is it possible to use a kind [corrected]
> of "OR" function into a "IF" function...
Thanks for your help....:D
You're welcome !
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"Bompi" <[email protected]> wrote in message
news:[email protected]...
> Thanks for your help....:D
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks