Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-16-2019, 06:03 AM
Haha88 Haha88 is offline If & And formula not working Windows 8 If & And formula not working Office 2010 32bit
Advanced Beginner
If & And formula not working
 
Join Date: Mar 2015
Posts: 46
Haha88 is on a distinguished road
Default If & And formula not working


Hi,

Can someone please help me identify why my if&and formula didn't work?

I attached an example sheet to show how the formula was formed.

Many thanks,
Haha
Attached Files
File Type: xlsx If&And formula.xlsx (9.9 KB, 3 views)
Reply With Quote
  #2  
Old 02-16-2019, 07:55 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline If & And formula not working Windows 7 64bit If & And formula not working Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,438
Pecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to behold
Default

Do you mean =IF(ISNUMBER(FIND("Database Management",A3)),"YES","NO")
Reply With Quote
  #3  
Old 02-16-2019, 09:49 AM
xor xor is offline If & And formula not working Windows 10 If & And formula not working Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,068
xor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of light
Default

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")
Reply With Quote
  #4  
Old 02-17-2019, 05:57 AM
Haha88 Haha88 is offline If & And formula not working Windows 8 If & And formula not working Office 2010 32bit
Advanced Beginner
If & And formula not working
 
Join Date: Mar 2015
Posts: 46
Haha88 is on a distinguished road
Default

Thank you both. It works brilliantly.
Reply With Quote
Reply

Thread Tools
Display Modes


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

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 10:14 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft