nested "if statements"

  1. N

    Seems basic, but not working. Assistance is much appreciated. Thanks.

    I am using a nested IF formula with multiple conditions that looks at two cells (D7 and C7). See below: =IF(AND(D7=100%,C7=100%),5,IF(AND((D7=100%),AND(100%>C7,C7>94%)),4,IF(AND(D7=100%,C7<95%),3,IF(AND(D7>89%,D7<100%),2,IF(D7<90%,1,0))))) The table that is used to qualify the resulting...
  2. C

    Removing #N/A from result of two IF statements and a Vlookup

    Hi all, I am trying to remove/leave blank the #N/A result of a formula containing two nested IF statements and a Vlookup. The current formula is: =IF(A2<>"",IF(A2<>"JOHNSMITH",VLOOKUP(A2,'Sheet1'!$A$2:$AH$143152,34,FALSE),""),"") I've tried placing an IFERROR before the entire formula as...
  3. Z

    Help w/ complicated nested IF

    Good Evening everyone! Thank you for taking the time to read and possibly reply. I need to update an IF formula (I didn't create it) and nest it with another IF formula, I have been looking and trying for a few hours and haven't made any progress. Because of the way the formula was created and...
  4. K

    Determine if Range contains multiple values, a single value or blank

    I have searched for this question but have not found an answer that works for my scenario. I have range J2:S2 that have flags (I'm just using the letter "x"). I need my formula to tell me if the range contains multiple x's (Multi), a single x (Single) or blank (blank). I was able to...
  5. R

    Nested IF with blank Value needed

    Hello, First and foremost, sorry if the title is confusing. I've been writing and staring at formulas so long words make little sense now. :stickouttounge: I work at a call center and am trying to write a formula for a workbook and am having some difficulty. Scenario: The work book has 11...
  6. S

    Nested if functions for part of a text string

    Hello! and thank you for helping me find a solution to this problem. Right now I have a very long nested function that has around 200 if statements and left functions. The function works great, but I can only go as far as 64. The purpose of this function is to get part of a string in a cell and...
  7. L

    IF/Nested IF Statement help!

    Excel & VBA Folks, I'm fairly new to VBA, but have been working hard to learn & help my company. I need help consolidating my code though, it's long & continually tests IF statements. The below code runs through about 1500 rows trying to match trade breaks to two seperate spreadsheets depending...
  8. B

    Sum till????

    HELP? This is my first post so please let me know if I can clarify what I'm trying to learn to do. I think in SQL they call this a SUM TILL. I think I figured out how to do it with nested IF statements but there has got to be a better way with INDEX, INDIRECT, MATCH, or OFFSET (maybe in an...
  9. S

    Trouble with a Index Match formula in VBA

    Hello all, I'm Trying to insert a line of code into a sheet's cell when a command button is pressed. I have three text boxes;tbMaterial, tbQty and tbCost. There a some materials that we use regularly so I already have their price listed (Ref_Cost). Other materials prices need to be entered...
  10. J

    Address sorting formula

    Good day all, New to the forum but here goes. I am using Excel 2013. I receive a list of addresses on a daily basis. but the address I receive is only the number of the house. The number determines the community name. example: address 52303-1 belongs in Comanche III community. the "-1"...
  11. S

    Is it possible to simplify these chained IF statements without lookup table?

    Pardon, I know this is rather confusing...I'm just having trouble thinking of how to simplify this and wondered if anyone had any ideas they'd care to share. I started writing a formula recently with a bunch of nested IF statements that's kind of spiraled out of control. I'm wondering if anyone...
  12. 5

    Multiple If(Match not working as I'd expect

    An Excel spreadsheet currently exists which has several years worth of data. In the past, exclusion codes were eight characters in length and they were always at the end of the comment. The previous formula worked fine before the exclusion codes were changed and the method of entering the...
  13. S

    Tax rate calculation

    I have spent literally over 4 hours trying to figure this out. Please, if you can help. SO, my boss wants me to have in a cell if someone makes less than or equal to 300000 then times another cell by 20% but at minimum the answer must be 25000 and in the same cell, if the person makes more...
  14. A

    SumIf with Logical Operators

    I want to build a formula that sums a column based on criteria that is greater than a certain number. I've tried nesting a formula, however, I'm doing something wrong. Basically I want to choose criteria from "Column A" where the value is ">4", and sum the data in "Column B" into cell "D2". This...
  15. B

    Nesting IF AND OR all together

    HI, I have a question card with 5 questions 1,2,3,4,5 going down column A1, A2, A3, A4, A5. I would like to work out the percentage of the score where the answers can be from 1-5 in column B next to its respective question number. BUT the questions can also be answered 0 if not applicable and i...
  16. W

    HELP! Apply a table of rules, using IF, AND and Ranges - at a bit of a loss!

    Guys n' Gals, My Excel is seriously rusty and i'm a little a bit at a loss as to how to deal with the problem below. I have 2 columns of data as outlined below, which depending on which rules they meet they are categorized as per the table below (see Example data) There are a set of rules...
  17. A

    Need help with this formula

    I'm using a nested If/And formula with 13 different logical tests. Basically, I'm trying to get an age value displayed when I enter a date of birth into cell B3. Of the 13 logical tests, I have 3 that span a number of years and then the other 10 are only covering one year. When I input the...
  18. P

    Today function in a If statement

    Hi everyone, Im trying to create a tracker that displays the current grade of my class to the main dashboard along with the progression number which is determined from the predicted grade to the current grade. say they were predicted an A and the current grade was a B the progress would be -1...
  19. K

    Case Select or Nested IF VB Statement Help

    I've read around and do not know if a nested IF statement Would be best, or a Case Select, or there may be something else I am unaware of that would perform better in my scenario. The responses in column T should be one of the following(answers are in bold) and should be answered for all data...
  20. T

    Using nested "if(or(isnumber(search.." to search in a string for text and return a value

    I am trying to build a nested formula that will search in a url string for a set of keywords and return a label. I have tried several different ways of doing this and have not been successful. Here are my attempts. Thanks in advance for any assistance on this question...

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