Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-23-2015, 11:19 PM
juhikothari juhikothari is offline Logical Functions - IF, AND, OR Windows XP Logical Functions - IF, AND, OR Office 2013
Novice
Logical Functions - IF, AND, OR
 
Join Date: Apr 2015
Posts: 1
juhikothari is on a distinguished road
Question Logical Functions - IF, AND, OR

Hello!



I'm working on an assignment - I have three values: "Yes", "No" and "Maybe".

A B C D E
1 Yes Yes Maybe Yes
2 No Maybe Yes Yes

I need a formula for Column E that fulfills the following conditions:

a. If the value in the rows is either "Yes" OR "Maybe", return "Yes"
b. If even one of the values in the rows is "No", return "No"

I've been unable to figure out a formula for this as it includes a group of cells. Please help!

Thanks in advance!
Reply With Quote
  #2  
Old 04-24-2015, 12:39 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Logical Functions - IF, AND, OR Windows 7 64bit Logical Functions - IF, AND, OR Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Perhaps
Code:
 =IF(COUNTIF(B1:E1,"no"),"no","yes")
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Logical cursor movement is not working capitala Word 5 12-08-2013 02:25 AM
Logical Functions - IF, AND, OR print logical pages with custom numbering livingem Word 1 06-06-2012 03:48 PM
Logical Functions - IF, AND, OR ** Using Functions djreyrey Excel Programming 10 02-08-2011 04:18 PM
Automated Functions?? nickypatterson Outlook 0 08-27-2009 01:50 PM
attaching (relative,logical or virtual) path to template word document wissam Mail Merge 0 08-04-2009 05:09 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:16 AM.


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