View Single Post
  #2   Report Post  
N Harkawat
 
Posts: n/a
Default

=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