If & And formula not working

		Microsoft Office Forums > Microsoft Excel > Excel
If & And formula not working

FAQ

Thread Tools

Display Modes

02-16-2019, 09:49 AM

xor

Windows 10 If & And formula not working

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,101

Pecoflyer has already given you a solution, but I also think that you are almost there yourself. Just change AND to OR and C3 to A3.

=IF(OR(A3="Database Management - Data Migration",A3="Database Management"),"YES","NO")

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula not working in Word 2016	evie073	Word Tables	1	11-28-2017 04:03 AM
ISNUMBER formula not working	bishweshwar	Excel	3	03-13-2017 10:07 AM
Formula working wrong, I can't identify why.	rajeshn_in	Excel	1	01-09-2017 03:59 AM
Conditional formatting not working with simple formula	bendmc	Excel	2	11-17-2016 11:31 AM
VLOOKUP Formula is not working	babs1234	Excel	3	03-04-2015 06:08 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:33 PM.