formula =or(and();and())

hi all, Need your guidance if possible on how to amend the below array formula to do a lookup all tabs listed below? =IFERROR(INDEX('4.RANGING CONVENIENCE'!$B:$B,SMALL(IF(B$1='4.RANGING CONVENIENCE'!$A:$A,ROW('4.RANGING CONVENIENCE'!$A:$A)- MIN(ROW('4.RANGING CONVENIENCE'!$A:$A))+1,"")...

Dear Excel Gurus I would be grateful for your collective thoughts on how to add days in school terms. I am sure it will be an IF(AND) scenario but can't seem to figure it out. We have 3 terms at school, each 8 weeks long, therefore 56 days. Students achieve various goals within each of these...

<tbody> < 2% 2 to 5% 5+ to 8% 8+ to 11% 11+% 0 to 10% 0.6 0.8 1 1 1.25 10+ to 15% 0.8 1 1 1.25 1.35 15+ to 25% 1 1.25 1.25 1.35 1.5 25+ to 35% 1.25 1.35 1.5 2 2.25 </tbody> Column growth: X Row growth: Y Multiplier: Z Given this table, I would like to write a formula...

Hi There I have a three shifts 06:00-14:00- Morning 14:00-22:00- Evening 22:00-06:00- Nights I have a range of times E2 Column such as 18:44 21:49 02:59 06:54 (ect) I want to return in the column next to the time if the time falls in-between the shift times whether its a Morning, Evening...

Hi All, I am looking for a formula for the following: I have a list of word, (FOV1, FOV2, FOV3, FOV4, FOV5, FOV6, FOV7, FOV8 and FOV9), which I would to find in a range of text in column A and have the searched text (FOV1 or FOV2 or FOV3 or FOV4 orFOV5 or FOV6 or FOV7, FOV8 or FOV9), returned...

Hi All, I can't get my head around this. <tbody> A-B-C Store %Conversion A 9,2% B 7,50% C 9,0 </tbody> So I have my A-B-C store and the expectation are different for all of them in terms of condition. Right now, I'm doing manually, but I'd like it to be automated. So when I enter the...

Hello, I am trying to create an IF statement for column H to determine an available time for each client. In column H, I am only looking at the preferred columns (B,D,F). If there are more than three duplicate times per column, I want column H to return with "Look at Preferred Options" so...

I need some serious help I need to create a date calculator but I need to exclude certain dates only if the end date falls on that date. For example, 1/2/15 and add 15 days... but here is where I am stuck... Only if the date falls on a weekend or federal holiday I need to skip to the next...

Excel for Mac 2011 Version 14.5.4 I've got a scenario where I'm trying to write an if/or function. Here's what I have so far: =IF(OR(C43=0,C44=0),0,IF(OR(C43<61,C44=1),0.05,IF(OR(C43>120,C44>4),0.15,0.1))). The logic is: if C43 is between 1-60 or C44 =1, then the discount is 5%. If C43 is...

Hello Everyone! I have a problem writing formula to ensure user filled both columns in case he fills any of them. lets say we have a table containing names and last names a - name b - lastname <tbody> robert mcdonalds stevens </tbody> And we have...

Hello Everybody, Currently I am working with a spreadsheet where I have to collect addresses of UK business Directors. Some of the directors have multiple addresses. UK zip code consist of two segment and I have to ignore the address where the first segment of zip code starts with W1 , SW1...

i'm very new with using VBA to solve the excel problems, but i have to work in rather complicated task : If the cells in route collums contain an exact strings of text(i.e: DMEVNSGN, DMEX/SGN, DMEVNSGN, DMEX/SGN or SGNVNDME,SGNX/DME, HANVNDME,HANX/DME...) it would return the value in the exact...

How can I separate a formula in excel that has the IF(AND ...function on it? It should be repeated over and over until it finds the right value in the array provided in a table to bring me back a formula that includes sum, and multiplying percentages. below is the way it should look, just by...

To all of you doing a wonderful job at Mrexcel I ask this simple question : I have a range (~100 cells in a column) that each has its own formula in CF but I'd like to check if there is at least one that is true. I already tried the solution proposed by Mr. Pearson (Conditional Formatting)...