nested

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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!

Hi all, I have a nested if statement and I am trying to add in if there is a #N/A to put a zero, but I am having trouble getting the formula to work. Any help please :) =IF($Y7="RevPro",SUMIFS('Q4-18 DRR'!$DX$4:$DX$50000,'Q4-18 DRR'!$K$4:$K$50000,$A7,'Q4-18...

Hello, I have a tricky, well, I think it is tricky formula I need to write. The idea is that any item that starts with "A" and number after "B" and numbers after "C" and numbers after "E" and numbers after or finally "K" and numbers after I would like the letter returned. Everything whatever...