IF OR logical function

		Microsoft Office Forums > Microsoft Excel > Excel
IF OR logical function

FAQ

Thread Tools

Display Modes

04-11-2018, 08:25 AM

NBVC

Windows 10 IF OR logical function

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.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Using IF Function where logical test is for range of values	guciolino	Excel	10	02-13-2017 08:05 AM
Search text using logical operations?	paik1002	Word	1	02-21-2016 11:48 PM
Logical Functions - IF, AND, OR	juhikothari	Excel	1	04-24-2015 12:39 AM
Logical cursor movement is not working	capitala	Word	5	12-08-2013 02:25 AM
print logical pages with custom numbering	livingem	Word	1	06-06-2012 03:48 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:56 AM.