How to use "or" in an if function: If C1=C2 OR if

  • Thread starter asf - ExcelForums.com
  • Start date
A

asf - ExcelForums.com

I am trying to make a spreadsheet with a cell that says if the valu
in C1 = the value in c2 or the value in c3, then the cell returns
"true

So we start with

=IF(c1=c2, "TRUE"

but I have no idea how to add "OR IF C1=C3" to the whole bit

help! :
 
D

David McRitchie

Use the OR Worksheet Function
=IF(OR(c1=c2,c1=C3) "TRUE", "False")
or since you would see number values as True or False anyway
=IF(OR(c1=c2,c1=C3))

You could do this as a Conditional Format, if you did not
want to use a column and wished to see color, but if you are
going to do more worksheet functions based on this result
then you would still want this in the worksheet or within subsequent
formulas.
 
A

Aladin Akyurek

=OR(C1=C2,C1=C3)

or to exclude evaluation when C1 empty:

=IF(ISBLANK(C1),OR(C1=C2,C1=C3),"")
 
Top