1. B

    Nested IFERROR/ISERROR statement

    Trying to write this formula and keep flat lining. If G2 is a error (always #VALUE ), return blank...otherwise run the below if statement IF(ISNUMBER(G2),"1","0") Can anyone help I am really struggling.
  2. M

    Sum Levels of Nested Subtotals

    Hello, I am trying to write a macro that sums several layers of nested subtotals. The lowest level subtotals (subtotal 2) are already calculated and pulled from another tab. Subtotal 1 needs to ONLY be the sum of the individual Subtotal 2 lines. In my example below, the first subtotal 2 field...
  3. K

    nested if gives #value

    I'm been working on a nested formula, with the other parts working but after a week I've worked out my problem is here and it still gives me #Value . After a full day trying several solutions I'm about to 'scream'...
  4. M

    Nested If in VBA Macro

    Hi Could you please help me to fix the below formula in column and its drop down (by increase cell count) till the last row in the VBA Macro =IF(C2<2,"0-1 Days",IF(C2<3,"1-2 Days",IF(C2<4,"2-3 Days",IF(C2<6,"3-5 Days",">5 Days")))) at the drop downing Column C has to increase...
  5. D

    Nested if 3 conditions

    Hello, can you please help point me in the right direction on this formula. Basically it has 3 conditions depending on day count. If <60 it should return “80%” If >60 but under 180 it should return 75% And if over 180 it should return 65% I am trying this but it wont work...
  6. D

    Nested IF formula

    I am attempting to write a nested if formula that currently looks like this =IF(I15:L15="NA","NA",IF(I15:L15="No","N",IF(I15:L15="Y","Y",""))) and am not getting the expected results. Currently cells I-L all equal NA. I'm sure I did something wrong and am looking for guidance to fix this or even...
  7. M

    Screwing up a nested IF function

    Hi. I'm creating a spreadsheet for a music group that pays tutor expenses for travel. For a round trip up to 200 miles the standard payment is £25, for a round trip of between 200 and 400 miles its £50, and anything over a 400 mile round trip pays £100. What I want is to be able to enter the...
  8. L

    MAXIFS Substitute, no Array to be used in an INDEX function

    Hi everyone, I just finished writing a decent TO-DO list that was to be used at the office while working on my home computer. Unfortunately my office doesn't have working MAXIFS functions with their version of Excel... I've looked up a few alternatives but I don't think an array will work...
  9. J

    Nested IF in Sliding Scale Formula

    Sorry. I know there is a simple solution to this and I’m just blind to it. Calculating Sliding Scale Percentage Current Formula in cell A46 =IF($B$33<5000,”.007”,IF($B$33<10000,”.006”,IF($B$33>9999,”.005”,””)))*10 This works perfect, however I need this formula to consider the value of A43...
  10. G

    For loop to create a top blank row

    Hi Guys, I am learning about nested loops but what I cannot determine is how to take values in a 2 dimensional array and through a nested loop move each row down 1 row and create a blank top row for new info to be inserted. I will call this sub over in over from my main code I am working on to...
  11. K

    Alternative to ifs function

    Is there another option if you can't use the =ifs command other than using multiple & if over and over? Thank you!
  12. C

    Indirect - Referencing tab

    Hi i am working on on a training matrix at work, there are 8 members of staff with a tab named after them. There are 58 odd tasks they need training on and have a measurement of out of 5 on the progress, if there progress is 3 or blow they still need training on that task. i have made a...
  13. J

    Nested IF Formula from IFS

    Hello, Might be an easy fix for you Excel experts but I can't seem to get the nested IF formula to return the results I need. The formula would look at number of days and return text as below: Convert the following IFS formula: IFS($AL13<=365,"Within One...
  14. L

    Exiting a nested for cycle

    Hello guys, I sometimes have for loops nested in for loops, but once i find my answer id like all of the loops to exit, not just the current one. My current code looks like: For Each item1 In fulllist1 For Each item2 In fullList2 If item2.Text = "hit" Then done = True...
  15. O

    unpivot using nested headers (multiple columns)

    Hello all, I have searched for a few days now how to unpivot via VBA. While I have found some helpful information out there, my situation is unique in that the desire is to unpivot nested headers. Horizontal groupings have levels. For example, below is simple example of what I am trying to do...
  16. M

    Outlook VBA: Copy nested PDF files in attached emails to folder on desktop.

    I regularly receive one email that has 50 or more emails attached to it. Each of those attached emails in turn has a PDF file attached to it. It is extremely time consuming to open the primary email, then open each individual attached email, then drag/copy each nested PDF file to a desktop...
  17. M

    Alternative to long nested IF formula

    I have developed nested IF formula that works fine but I have to use it in 44835 cells that makes my Excel file 4,8 Mb in size and worksheet pretty slow on i5 Intel with 8 Gb of ram. Is there any way to rewrite formula to make it more efficient or maybe do something else to speed up my program...
  18. A

    Nested IF(nested if statements) and if(nested if statements) logic

    I think I read all of the "nested if statements" in the forum but I couldn't find my solution - so sorry for starting another one! Here is my situation: Field AM5 possible values: F, FA, LTI, RMTC, OI, OILWL, [blank] Field AN5 possible values: E, DC TP IF AM5 contains: F, LTI, RMTC, OI...
  19. F

    Nested IF statement with multiple criteria

    I have a spreadsheet where I'm trying to put together an IF statement which meets multiple criteria. Outline below: Column B - Type - "Risk" or "Issue" Column I - Probability - "1/2/3/4/5" (validated cell) Column J - Impact - "1/2/3/4/5" (validated cell) Column K - Rating - product of Column B...
  20. P

    Nested If Statement with Calculations

    I need to enter a formula in a cell that does the following: If S2= ‘L’ then multiply V2 by W2, If S2=’R’ then multiply T2 by U2, If R2 =’S’ then multiply X2 by Y2. Thank you very much to anyone that can help with this!

Some videos you may like

This Week's Hot Topics