nested "if statements"

  1. A

    Unable to put multiple IF(AND conditions

    Hi This is my excel file I am trying to put a band automatically in column W but it is not happening What I need is that if an Employee salary is >= 15000 but less than 20000 then he/she be in Band "I" similarly in increments of 5000 till band "XV" However the above formula is sending an...
  2. R

    EXCEL: Find name and return multiple values

    Hello all, I am a newbie with excel, so I'm hoping someone can help out. in the workbook I'm working on, I have multiple tabs with data spread out. Tab 1 contains a list of resources and the dates they will end support. Unfortunately, some list the full name, and others list just the first...
  3. V

    Pulling out my hair trying to figure out this formula... please help!

    Hi everyone, I am very basic when it comes to excel, and thought I could figure this one out, but alas, I need help please. I have a drop down list in column E, cell that has the following options: Low, Medium, Medium-High, High, New Depending on on that choice, I would like to return a value...
  4. R

    Nested IF formula Nightmare

    Hey Everyone, I have gotten most of my formula to work but I need to add one more condition and I can't seem to figure it out. Here is what I have so far (that I've tested and works)...
  5. M

    Removing "Blank" Result from cell

    I am using a formula in which the results "low", "medium, or "high" will appear (in column U) based on the numerical value that is entered in another cell (in column T). =IF(T3<>"",IF(T3<=59,"LOW",IF(T3<=79,"MEDIUM",IF(T3>=79,"HIGH","")))) It works perfectly, however the word "FALSE" is shown...
  6. J

    Case statement using nested ifs

    Hey All! I am running into an issue I can't figure out. I've got a big set of data and there is a specific column that I want to make a case statement based on the results. If the field, lets call it A1, is... =42 or =43 or is between 70 - 99, excluding 79 and 81 then I want to call it "Yes"...
  7. A

    Iferror miscalculation

    Interesting one for you all - Excel 365. If I use a simple formula to subtract 1-1 I get, as you would expect a 0 (Row 2) However, if I nest this inside an iferror formula I get a very strange answer (yellow cell). (Row 3) Anyone any thoughts on why this is happening?
  8. K

    Nesting 2 completely different IF statements?

    Hi, Hoping someone can help me. Currently i have 2 separate IF statements checking for separate conditions: First one checks if 1 cell is blank, and a corresponding one isn't and will result in a string of text: =IF(OR(ISBLANK(H2<>""),ISBLANK(A2)),"No Deal Reg - Contact Opportunity Owner","")...
  9. J

    Nested Function, Too many arguments error

    Hello, I tried to add this last line IF('[EUCOM Revised SEMA Training Matrix 20220219.xlsx]Conditional '!$D5-TODAY()<1,"OVER","" To a function that was working. Now it says I am getting an error for too many arguments. Here is the new formala below. Please help. =IF('[EUCOM Revised SEMA...
  10. J


    I have data in col A (item) I need to know if it is repeat or new. the thing is, all item starts with 302 are new (N) item number, but if this item is repeating(starts with 302), I have to tag it as Repeat (R). i have the formula to find if it is repeating. =IF(COUNTIF($A$1:A1,A1)=1,"N","R")...
  11. I

    Dynamic Nested If Formula Use dependent on Cell Text

    I have 3 categories (Priority, Less, None) that correlate to a specific NESTED IF Function but only differs in the percent within the calculation. Overall, the result of the use of the formula provides a Status of behind, ahead, on track etc. I currently have the status only populating with...
  12. T

    IF(Count not working for 2 values

    I have data in columns M through Z. Based on how many columns have data in a specific row, i want column B to give it a category. When trying to past the below formula into B2, I get window stating "there is a problem with this formula". =IF(COUNT(M2:Z2)=1,"1st to 2nd",IF(COUNT(M2:Z2)=2,"1st...
  13. P

    Generating a Unique, Sequential ID in Excel According to the String Value in Another Column

    In Column A of my excel sheet I'm trying to create a unique, sequential ID in each row according to the 'activity type' in Column C. Activity Title is in Column B, but the two relevant columns for this example are Column A and Column C. There are three activity types: Milestones, Tasks, and...
  14. riverspree16

    Chain of IF conditions

    Searching and trial and error have not gotten me anywhere, so hopefully, I can get a tip as to whether something is wrong with my formula, or if I'm using the wrong kind of formula(s) altogether. I'm working with a series of billing codes, and one has a different rate of calculation than the...
  15. JEH105

    Nested IF, OR, and VLOOKUP formula is not distinguishing text.

    I built a PTO calendar dashboard where it automatically updates the employees availability for the day based on the calendar's data. The options vary from U (unscheduled), holiday, jury duty, covering, or a value over 1 is added. This is what it looks like: =IF(OR(VLOOKUP(N28,table...
  16. E

    Formula To Identify If Cell Dates Occur Within 30 Days of Adjacent Cell Date

    Hello y'all, I've got a simple formula to identify if a date in W4 occurs within 30 days of a date within X4: =IF(W4+30>X4,"Readmission Present", "No Readmission"). I'm trying to expand the formula to have it include this date comparison for the next 24 rows. As in, also including...
  17. A

    Please help with my runtime error '424' object required

    Here is my code: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$E$70" Then If Me.Range("E70") = "Yes" Then If Me.Range("E9") = "" Then MsgBox "Please enter school ID at the start of the form to continue"...
  18. Z

    Years into groups

    Hi! I have column which has several termination dates and what I need to do is to group those dates into years as showing below: - Less than 1 year - 1 year - 2-3 year - More than 3 years What is the best formula to use? Thanks!
  19. B

    Multiply Cell by Two Different Numbers Based on Range

    I am attempting to create a formula in B6 that considers the following criteria: If SUM B1:B2 <100 then SUM(B1:B3)*28 If SUM B1:B2 >100 then multiply the first 99 hours by $28 and every hour worked thereafter by $32. Then add B3*28. * B1 & B2 are the only hours to be considered regarding <...
  20. S

    Nested IF

    I’ve done a nested IF, contains 4 or 5 criteria returning a Yes or No. Why would it return a True or False when adding an additional criteria if I’m returning a Yes or No and presenting incorrect results?

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
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 "".
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