Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to use "or" in an if function: If C1=C2 OR if
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 |
#2
|
|||
|
|||
=IF(OR(C2=C1,C1=C3),"true","")
"asf - ExcelForums.com" wrote in message ... 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 |
#3
|
|||
|
|||
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" wrote in message ... 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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
=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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
clock | Excel Worksheet Functions | |||
Function Won't Calculate -- Sometimes | Excel Discussion (Misc queries) | |||
Need a ISWorkday Function -- Any Ideas | Excel Worksheet Functions | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions |