Thread
:
IF OR logical function
View Single Post
04-11-2018, 08:25 AM
NBVC
Windows 10
Office 2013
The Formula Guy
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
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.
NBVC
View Public Profile
Find all posts by NBVC