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

[asf - ExcelForums.com]

I am trying to make a spreadsheet with a cell that says if the value
in C1 = the value in c2 or the value in c3, then the cell returns a
"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

[N Harkawat]

=IF(OR(C2=C1,C1=C3),"true","")

"asf - ExcelForums.com" <[email protected]> wrote in
message news:[email protected]...
>I am trying to make a spreadsheet with a cell that says if the value
> in C1 = the value in c2 or the value in c3, then the cell returns a
> "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.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"asf - ExcelForums.com" <[email protected]> wrote in message news:[email protected]...
> I am trying to make a spreadsheet with a cell that says if the value
> in C1 = the value in c2 or the value in c3, then the cell returns a
> "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
>

[Jimbola]

Hi

Use

=if(or(c1=c2,c1=c3),"TRUE")

HTH

J

"asf - ExcelForums.com" wrote:

> I am trying to make a spreadsheet with a cell that says if the value
> in C1 = the value in c2 or the value in c3, then the cell returns a
> "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
>
>

[Aladin Akyurek]

=OR(C1=C2,C1=C3)

or to exclude evaluation when C1 empty:

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

asf - ExcelForums.com wrote:
> I am trying to make a spreadsheet with a cell that says if the value
> in C1 = the value in c2 or the value in c3, then the cell returns a
> "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
>