and & or statement

  1. W

    INDEX, MATCH WITH "&"

    =INDEX(A:A,MATCH("9-"&U29,F:F)) I want the above formula to return a value from column "A" by matching "9-number" from F column. For example, U29 cell = 135. So 9-135 would be in F:F column and it would give me the data in A column. Please help. Thanks!
  2. D

    Simple Nested And, Or formula based on three conditions

    Hi all, I am hoping someone can help with what I think should be a pretty easy formula, I am trying to return a value of “medium” or “high” based on if W11 is blank & P11>5 for three different criteria in N11 “average”, “poor” or “good”. I don’t understand why I am struggling with this so...
  3. P

    Multiple AND statements, long formula

    I have a dataset with 500+ athletes, each with information on age category, best distance, season in which PR was achieved, and the absolute time of the PR. On another tab ("SBT") I have the overall season best time per age category on 6 distance over 5 seasons (total of 150 season best times)...
  4. N

    Needing help with a complicated Ifs/and/search please

    I have a field of data which needs to be compared in multiple places, I keep almost getting there but am missing the final bit to make it work, would appreciate any assistance with this! One table of data has an individually coded number which needs to be searched for in the other table of...
  5. U

    need to solution on more nested IF (error getting this formula uses more levels of nesting)

    Hi all, I'm having issues with the below-nested loop. (error getting this formula uses more levels of nesting) this is matching like below e.g: if the F4 value between 48 and 61 then 4000 need to print =IF(AND(F4>=48,F4<61),4000, IF(AND(F4>=61,F4<76),5000, IF(AND(F4>=76,F4<91),6000...
  6. A

    IF AND/OR Help!

    Hi all, I've nested an if and/or formula and all seems to be working well except for one odd result. I was wondering if someone could help. Attached is a screenshot. The formula reads as follows for row 3...
  7. R

    IF/AND/OR Nesting

    Hello - I am looking to create a formula that will return 'YES' or 'NO' based on different factors.... Without going into detail on the other parts of the formula unless necessary, the entire formula works until I added the bolded section below...
  8. L

    True or False statement using the AND function

    I ran into a speed bump yesterday and today with a true or false statement from data in a single column containing a speed (see attached picture). Most, if not all, speeds are two digits in length; however, yesterday and today I had several speeds post in single-digit format (i.e., 3, 6, 8...
  9. MrDB4Excel

    Program List If Function

    I have a worksheet containing cells G3:G100 that needs text and fill formatting via a “Conditional Formatting” rule that looks at the corresponding cell in the “H” column to see if the text contains any one of the letters B, D, F, H, J, L, N, P, or R. The actual contents in H3:H100 are any one...
  10. H

    AND & OR Together?

    hi I am trying to get a particular result, but I have obviously got the syntax slightly wrong in my formula and I wonder if someone might look at it and indicate where I went wrong. Here is the formula:- =IF(AND(Q2="L",P2<=2.2,OR(Q2="P",P2<=2.2)),95,IF(AND(Q2="W",P2<=2.2),-100*P2+100,0)) In...
  11. U

    Excel Formula Query - Adding OR to function

    Hi aLL, Have the following formula which works fine, however want to add to it so that it looks for not just the text "A1" but also "B1", how can i amend the below formula? =IF(RIGHT(TRIM(D2),2)="A1","YES","NO") Thanks,
  12. U

    Adjust Sumproduct construction with Dropdowns

    Hi all Is there a way to construct an AND & OR sumproduct lookup that uses Tickboxes alongside a criteria range and also a toogle to state which of the list should be used as an OR or an AND criteria to adjust the outcome...
  13. A

    Multiple IF, AND, OR help please...

    Hello All - Thanks so much for any ideas you might have on this: I am trying to combine the following statements, each of which seem to work fine on its own, into one statement. Have googled, have searched here - surely I am missing something fundamental. Many thanks for suggestions...
  14. M

    Help fixing my AND/OR formatting rule

    Hi, I am just after a little help in fixing a formatting rule that I have written as a conditional format that I have written for QA work. Here is the code I have written: =OR(AND(SEARCH("missing",K1),M1="No"),AND(SEARCH("lost",K1),M1="No")) Basically I want the format to highlight when a...
  15. K

    Count specific values within subgroups of groups

    Hello everyone, I am having trouble with counting instances where a specific value appears within a subgroup of a group. An example of the data are below: <tbody> GROUP ID DATA 1 1 Main St 1 1 1st St 1 2 Main St 1 2 2 1 Main St 2 1 Main St 2 1 2 2 1st St 2 2 </tbody>...
  16. N

    Multiple IF AND OR Statements

    I'm trying to nest multiple IF statements, along with IF(AND(OR) statements within one cell. The "Premium Table" I have to use is below, along with a sample of the the worksheet. The question is: What IF statement do I enter in cell D2 to obtain the correct premium? Premium Table Age Range -...
  17. O

    Forecasting with several conditions

    Hello, I'm trying to forecast values along down a table. I have already used Forecast (Linear) formula without a problem, but now I need several conditions to be met. This is what I have so far: {FORECAST.LINEAR([@Date];AND(IF([Date]>=([@[Date]]-5); [Score];"");IF([Date]<[@[Date]]...
  18. A

    if & Or statement in VBA.

    Here are my code: Sub GL()With Application .EnableEvents = False .ScreenUpdating = False End With Dim i As Integer For i = 2 To 20000 If Trim(ThisWorkbook.Sheets("FRA&FFC").Cells(i, 6).Text) <> "" Then If...

We've detected that you are using an adblocker.

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.
Go back
Back
Top