# or function

1. ### I don't understand why my formula won't work?

Hi! If anyone could help with this, that would be very very helpful! I am trying to identify in Cell U2, people who either missed a class many times in once month, or consecutively missed classes in the following months. So I would like Cell U2 to say "TRUE" if either S1 or T1 say "TRUE". I...
2. ### Whats wrong with my formula

Hello, anyone want to take a stab at what is wrong with my formula? =if(and([@inches]=0,[@[Length feet]]=6),6,if(and([@inches]=0,[@[Length feet]]=8),8,if(and([@inches]=0,[@[Length feet]]=10),10,if(and([@inches]=0,[@[Length feet]]=12),12,if(and([@inches]=0,[@[Length...
3. ### CountIf Function with range

I have two different columns on different worksheets that I want excel to count. currently I am unsure on how to add another logic to this formula please help. So basically I want excel to count if 'Upload New Class'!\$B\$2 is found in table 1 with range's X-Z OR table 2 with ranges X-Z...
4. ### Challenges with Countifs function

Using excel 2016. I am working on a call schedule and trying to make some calculations based on assignment and day of the week - specifically the weekend. The following formula works great - =COUNTIFS(Vertical!G11:G27,'Names and Values'!J11) When I run this the formula returns the assignment...
5. ### Using IF, AND, OR together

Since you are all so wonderful at helping, I have another question. I'm trying to nest IF, AND, and OR together. I want to tell it IF Q2<12, OR R2<12 AND B2=V are TRUE, then A5, if false then A4. My current working formula is however it doesn't have the AND function in it because I'm not sure...
6. ### Using the OR function

I'm trying to add an OR function to an IF function. I want to say if Q2 or Q3 <12 then A5 otherwise use A4. I can get it to recognize when I say just one-like Q2, but can't get it to recognize both Q2 and Q3. I've got =IF((OR(CSV!Q2<12)),.... Which works fine, but when I put...
7. ### Minifs with OR criteria

I'm trying to create a list of unique project numbers that have outstanding invoices. I have a data query which pulls data into my Data! tab, the query returns the age of the invoices in date range buckets (eg <60 days, 61-90 days, >90 days). That is, column L has the amount of money owed that...
8. ### OR function in an array

So I am trying to add an OR function to my array but I either get all False or all True. Compared to a certain date, I want to display the date of when an item is upgraded with either: Type_1 Type_2 with Ver_1 Type_2 with Ver_2 If any other item type comes up (example: an item has an upgrade...
9. ### IF, AND, and OR Formula #VALUE error

Background: I'm working on a constructed language, and wanting to use an Excel formula to check that the rules are being followed as words are created. So the first rule I'm trying to check is that the first letter of a word, depending on the type of word (Noun, Verb, Adjective, Adverb, and...
10. ### Trying to build an ARRAY formula with OR conditions that returns result based on a range of numbers

So I've got this far: {=IFERROR(INDEX(\$B\$9:\$B\$496,SMALL(IF(\$C\$9:\$C\$496>G\$507, +IF(\$C\$9:\$C\$496<g\$508,row(\$b\$9:\$b\$496)-row(\$b\$9)+1)),rows(\$b\$9:\$b9))),"")} We are dealing with a list of Standing Order payments from customers. Each has a different day of the month. I need a way of finding which...
11. ### Can anyone help me fix my formula?

=IF(OR(IF(MONTH(B25>B24),C\$3+F24,F24),(IF(MONTH(B25=B24),F24,C\$3+F24))) Basically I want a result for the or function, not true or false. However it keeps saying I don't have parenthesis in the right spot. The 2 IF functions are different but the answers for the IF function are the same. Can...
12. ### Nested IF AND OR Function

Hello - I'm trying to evaluate the contents of two cells with 4 possible values. I3 can contain either Active or Inactive J3 can contain either YES or NO IF I3="Active" AND J3="YES" OR IF I3="Inactive" AND J3="NO" THEN "Match" ELSE "No Match" I've tried several combinations and am not getting...
13. ### IF, OR FUNCTION with dates

=IF(OR(C111="YES",D111=""),"YES","") Hi all i am trying to create a formula that will return the word "YES" if criteria is met in cells C111 and D111 C111 either has YES or NO filled in the cells, while D111 has different dates, with some cells blank. I am struggling with cell D111 as i dont...
14. ### Counting certain text in a selection

Hi all, I've got this code, & it's not bringing back the results I'm after. =(IF(OR(COUNTIF(K7:M28,"No - Major")>0,1,COUNTIF(K7:M28,"No - Minor")>2,2),"")) K7-M28 are the cells (columns K, L & M are merged cells on each row). Basically if any of these cells have a "No - Major" in them then...
15. ### Need Help with Two Condition Combination Formula

I need some help creating a combination formula that checks for two conditions to be true. Column A and Column E in my spreadsheet will contain random values of which may or may not be listed below. My current formula in cell E* checks to see if the value in Cell F* meets the condition of...
16. ### IF/AND/OR Functions HELP

Good Morning. I’m having a hard time writing a formula. Every time I do it get it kicked back so I needed some additional help from people. I am attempting to write a function that states if a person is located in the USA and hit their target of 0% or higher they get 10 points. If not then...
17. ### Using OR in SEARCH String

Hi All, So i wrote an excel equation to spit out a date based on 2 criteria. If it has a 1, 2, or 4 in one column then an A, B, or C in the next column it gives a result. Then if it has a 5, 6, or 7 in another column and a A, B, or C it gives a certain result. I have the equation done other...
18. ### Networkdays Formula IF/OR Cell has Open or Closed

Hello Excel Gurus! I am befuddled over an IF/OR function in Column M (M2) of Networkdays where if Column L (L2) has "Closed" as a status Networkdays calculates the difference between J2(start date),K2(end date),HOLIDAYS in M2. But if Column L (L2) has "Open" as a status Networkdays calculates...
19. ### Looking for solution for using SUMIFS and perhaps a nested OR function ...

Hi, I wanted to ask if there is a way to use a SUMIFS with a criteria set that can “vary”??? Need to “SUMIFS” with multiple factors (DATE, ROOM NUMBER, ROOM USED FOR, etc) such that the ROOM IS USED for either ALL TYPES OF PROCEDURES(ELECTIVE, URGENT, EMERGENT, Add-On), ELECTIVE ONLY or...
20. ### Formula help: not IF function and not changing text

Hi everyone, This is my first post, so thank you everyone for all the help I'm sure I'm going to get! I am trying to write a formula using the IF function and OR function. I basically want it to say: IF (OR (certain cell = this, certain cell = that, ""), __________) The _____ is that if the...

### This Week's Hot Topics

• populate from drop list with multiple tables
Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
• Find list of words from sheet2 in sheet1 before a comma and extract text vba
Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
• Dynamic Formula entry - VBA code sought
Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...