#1
|
|||
|
|||
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! |
#2
|
||||
|
||||
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 |
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 |
print logical pages with custom numbering | livingem | Word | 1 | 06-06-2012 03:48 PM |
** 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 |