I've tried to make this formula more concise using the OR function, but it doesnt need to like it.
Have I done something wrong?
Any ideas how to make it work?
Before OR Function (Works):
=IF(ISNUMBER(SEARCH("M&E",D$41)),"Electrical &...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
=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...
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...
=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...
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...
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...
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...
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...
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...
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...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.