nested "if statements"

  1. E

    If Statement With Multiple Vlookups

    I can't figure out why my result is returning FALSE. Here's what I'm trying to do: If A1503 equals "System Certified", then perform the vlookup using the value value from cell G1503. If A1503 does not equal System Certified then perform the vlookup on the value in cell AX1503. Here's my...
  2. W

    Need help to find correct formula! Multiple criteria and range levels

    Trying to come up with a formula for a Sandbox that calculates an employee bonus's Criteria 1 - Type of Mgr - These 2 levels receive bonus based on % variance to budget * General Mgr * Asst Mgr Criteria 2 - Type of Mgr - These 2 levels receive bonus based on Store Level Sales (4 levels of Low...
  3. D

    Trying to figure out nested IF AND OR statement... please help!

    Hello... I work as a Quality Assurance Analyst and I am needing assistance with coming up with a very complicated nested formula. I am creating an "accountability" track sheet for Agent's audit scored for each month. Here is our workflow with their Supervisors/Management: - Agent's monthly...
  4. H

    Nested If, countif, sumif, etc

    Long story short having problems figuring out how to do this. Does this look wrong or not possible? =if(Log!D2:D1000=B2,countif(Log!Z2:Z1000,"Over"),+0) In words If a cell on sheet Log in the range D2-D1000 is the same as cell B2 on the current page, count the cells in column Z on the Log...
  5. E

    Make this formula take more than three if statements

    I have a pretty complex formula and I would need it to take more than three if statements. Right now it it says: If first condition is met, "use this if" if true, and "use this if" if false. I need to chain 9 different ifs. So basically I need it to say "If first condition is met (this is one...
  6. F

    If Statement (maybe) that takes into consideration several factors

    Issue: Need to calculate the times per person, per day using minimum/maximum (or that's how i figured it out). Each day, there could be multiple timestamps. Need to figure out the oldest and newest, then calculate the time in between that based on person and day. Appreciate any help Example...
  7. E

    Formula to Find which category a value falls in

    Hi all, I have a spreadsheet that looks like the following <tbody> Benchmark Benchmark Benchmark Benchmark Benchmark Wages 10th 25th 50th 75th 90th 65,000 100,000 200,000 300,000 400,000 500,000 300,000 100,000 250,000 298,000 350,000 400,000 180,000 50,000 60,000 70,000 120,000...
  8. A

    help with if statement

    Hi all, I am having trouble with a nested if statement. I have several columns of data I need help with a formula that will look at the first column of data in column B if nothing found then go to Column C if nothing go to D if nothing go to E. If all the columns are blank then pull value from...
  9. B

    IF Formula - nested

    Hi, I need to create an IF formula based the following information (my goal is to have a column with hourly rate per employee, whether they are hourly or salary so I can do a vacation accrual - see details below): col BC this column says either SALARY of HOURLY on each line (by employee) col...
  10. reneev

    Nested IF statement, what am I doing wrong?

    I have a formula that is currently working: =IF(H3<>"PD 1 HMS W/DIFFERENTIAL","",M3*1.1) I need to add a second formula that does the same thing, but looks for "PD 2 HMS W/DIFFERENTIAL". I thought I knew how do do it, but keep getting an error that there are too many arguments for this...
  11. F

    Nested IF Statement - I think

    Trying to put together a formula to tell me the number of hours based on the following parameters: 1. Time between Online/Offline 2. Online always is first 3. How much time between Online and Offline for the day 4. Some times multiple entries for a person within a day 5. Sometimes Online will...
  12. J

    Nested IF AND/OR function

    Hi all, I'm trying to write an formula for an audit. The questions is, if a patient is on a particular drug 'A', are certain numbers within a certain range - for instance if they are on drug A, and they are over 80, or a serum creatinine of over 133, or a weight of under 60kg, or a creatinine...
  13. L

    Nested if statement to look in between multiple date columns to see if tag is applicable based on 1 date

    Hi everyone, I need help writing a nested if statement to solve for the "desired result" column. I need to look in between each of these dates and determine which was most recent to the "comparison date", and display the "desired result" tag. The combinations on this are driving me crazy and I...
  14. T

    If time is 1:00 AM throws value if false

    Situation: Simple nested IF statement that looks for time in one column and returns value in another column. Formula: =IF(E46=TIME(3,0,0),I46,IF(E46=TIME(2,0,0),H46,IF(E46=TIME(1,0,0),G46,IF(E46=TIME(0,0,0),AD46,IF(E46=TIME(23,0,0),AC46,AB46))))) Hint: This formula is in column AF Expected...
  15. sdkorin

    IF function

    I need a little help with what I thought would be a prettysimple if function; however, the solution seems to allude me. I have 3 columns. Column H is going to generate text (“Yes”or “No”) based on what’s in columns I and J. Columns I and J are for dates someone is certified in aparticular...
  16. A

    Dividing Nested IF/AND sum

    Hi! I'm still learning to use nested formulas, and I'm trying to divide this particular formulate below by 7, but when I put /7 the output is incorrect (in this case the sum is 24 but the output of when I put /7 I get 20 - which is definitely not right). Please help...
  17. K

    Nested If Formula Problem

    Hi all, I have a problem with a nested if formula where what I need is a number to appear i a column depending on the numbers founds in another column. I think I have something wrong in the formula because it does not work like that. If someone could help me it would be much appreciated. The...
  18. Z

    Nested IF

    Hi, I have 2 conditions in two cells and I need these conditions to be combined in one cell, below are the conditions: =IF($X$5="Global",SUMIFS(Galaxy_Data!$T$2:$T$471,Galaxy_Data!$E$2:$E$471,'It would take'!$X$5,Galaxy_Data!$B$2:$B$471,'It would...
  19. tycasey17

    Nested Ifs Based on the Calendar Year

    I have been trying to have a nested IF statement based on the year. It seems like the year portion is causing the issue but I cannot seem how to fix this, I am trying to have multiple years on the same sheet but have a formula to pull up by the year I select. SAMPLE FORMULA: IF(A1="2019"...
  20. K

    Nested IF A is blank then use B, if B is also blank then type "X"...

    I did find a thread that came close to my solution... but not quite :-\ I have two columns K and L. If L is blank use the value of K. That worked out just fine with: =IF(L40="", K40,L40) My question is how to add an additional condition of: IF K40 is also blank THEN type "Unassigned". It...

Some videos you may like

This Week's Hot Topics

  • help please
    SORRY NOT ANY GOOD AT EXCEL SO HELP WOULD BE MUCH APPRECIATED this formula is in a sheet called ignore...
  • two formulas needed
    Hello, I'll try my best to explain this: First formula needed in Sheet1 cell A2: If Sheet1 cell B2 = Sheet2 cell B2 then return a 1. If not then...
  • Dynamic Counts
    Good afternoon, we are tidying up some data & the data seems to be growing quicker than we are tidying it up! What we confirm (by reviewing it...
  • Help Excel formula eliminate duplicate values and keep only 2 identical rows.
    as picture below column A has a duplicate value. but the values are not the same as the rule. sometimes 4 rows, sometimes 10 rows or 7 or 9...
  • Macro Compile Error Sub or Function not defined
    Hello, I am trying to run macros from a validation list, all macros have been created and run perfectly on there own but I'm getting a compile...
  • Last row combined with Current Region VBA
    I'm generally happy finding the last row of data through something like Lastrow = Cells(Rows.Count, "D").End(xlUp) but I don't always receive data...
Top