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 <atyahoo<dotcom ---- Bompi 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 <atyahoo<dotcom ---- "Bompi" wrote in message ... Thanks for your help....:D |
All times are GMT +1. The time now is 06:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com