Hi,

I have a question about IF logical function. So, the condition is: if any of cell A5,B5,C5 are filled with letter X, then cell D5 should be filled with letter X as well. Otherwise (else), it should remain blank. I beleive IF OR function should be used, but...

You can see the attached pic.
Thanks

Attached Images

Capture.JPG (18.9 KB, 17 views)

In D2 try:

=IF(COUNTIF(A2:C2,"X")>0,"X","")

Then copy formula down.

or you can use =IF(OR(A2="X",B2="X",C2="X"),"X","")

This latter formula is okay for 3 columns, but if you have lots of columns to check the former formula becomes the better choice.