OR function into a IF function

H

Hayeso

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")
 
M

Max

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"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hanging indent, indenting all lines! 4
Excel - Wich Function should I use? 1
Drag and Drop does not work Outlook for Mac 0
How to Select Multiple Emails using Surface Pen 0
Viso Wizard no launching? 0
Excel 2013: How to ensure a cell is not left blank by users? (Not using VBA) 0
Use TODAY() function as the criteria in a SUMIF formula 1
Link a text box based on drop down box with four options MS Word 365 0

Top