nested

<tbody> Job# Name Type Stage 1010 Elm Ranch Residential Design 1012 Oak Park Dev. Non-Residential Design 1015.5 Beechwood Estates Mixed Use Planning </tbody> I have worksheets spanning the last 6 years detailing jobs. The earlier (2013-2015) worksheets don't have type and stage, which I...

Please help! I'm stuck with this macro. When I manually do a nested If statement with OR formula it works fine. But when I convert it to a macro, it errors out. What's frustrating is that this macro worked before with less OR formula statements. The revised one has a total of 30 OR...

Hello All, I'm having trouble with a large formula in Excel. The spreadsheet has over 2,000 rows and 35 columns. I'm adding two columns (making it 37 columns) for the formulas. I have completed the one column with a multiple nested IF statement, but for whatever the reason, cannot get the other...

Hi, New to the forum as I have a problem with a work sheet that has been bugging me all day. For example I want cell H5 to return the number of pallets it would require depending on the number of cases (I5) We can fit 126 cases onto a pallet so if I5 is between 1 and 126 then H4 should...

I am not sure that I'm using the most efficient approach to what I'm trying to achieve. Input and advice is most welcome. I'm sure this is a simple formula, but I'm not having and success with it. <tbody> IF(AND( A1 > 9, and < 20, and B1 = "PHONE"), (DO THIS) </tbody> <tbody>...

Hi all, I need a formula to "bucket" numerical values into groups / categories Something along the following lines : <tbody> Age Age Category 1 0 - 2 2 0 - 2 3 3 - 7 5 3 - 7 8 8 - 15 12 8 - 15 17 16 - 30 34 31 - 90 106 90+ </tbody> I...

Hello all - I would be very grateful for any help with the following: A very helpful board member, jtakw, helped put together the following...

Hi, I'm trying to count the number of times the letter "O" appears in any column where the first row =1, then 2, and so on: I've been playing around with =countifs() and variations of nested =countif() without luck. Does anyone have any tips to help me with this please? Cheers, Pete

I am trying to write a nested IF AND Function to produce a result off of a Tiered Fee Table. A . B . C . D 1 . Condition 1 Condition 2 Result if True . Result if False 2 . 1,000 2,000 1.7% ...

Hello guys. I am currently facing an issue related to how to allocate the difference between some dates into specific years. Let's assume the period below. <tbody> start_date end_date 03-03-2015 5-06-2017 </tbody> Given this period, I would like to compute the days corresponding to each...

Good Morning, Probably pretty easy for you guys. Looking to do a nested if statement for a vacation accrual calculator. Basically I have a hire date in B1. In C1 in want to do a nested if statement with the following parameters. if B1 is less than 1 year from date in A1 (first day of...

Good morning, This is an odd one, and I am not putting it in the right words to find elsewhere. I am working on a sheet with numerous Index/Match and Nested IFs. All of these return "" with no manual data entered. The problem is that some of the formulas are comparing the values in some...

Situation: I have a spreadsheet I use to track tenants and payments, balance due, etc. Each month (12 sheets) a balance due column is figured based on charges and payments for that month plus the balance carryover from the previous month (if any). Each row is by address, but tenants change...

Hi, Can someone please help me with this? I have a table like this: Code --> Column A: ZSA, SAW, GEN, PT1,SSS, AAA,... Phase---> Column B: Phase 1, Phase 0, Phase 1, Phase 2,Phase 0, Phase 1,.... Task-->Column C: 05-11, 05-4, 05-78,05-8,05-13,05-20...... I would like to create a new column...

I am using a nested IF formula as such: =IF(A1="7eng.com","7G Enterprises LLC",if(a1=”a4gov.org”,”City of Ann Green”,if(a1=”abonaire.com”,”Abonaire Consultants”,” “))) Dragging this formula down the column, it will work and populate a cell with "7G Enterprises, LLC" if it meets the first...

Please can someone help me with a nested if formula. Understand the concept just cannot get it to work. I’m wanting to band a set of data into categories as follows: Less than 20 = small 20 - 59 = medium 60 - 99 = large 100 plus = extra large If someone could post me the foruano for this I...

hi all and thanks for your time! i am having trouble getting this formula to work. is it true you can only have 7 nested if statements? here is the formula...

I have a fleet of truck I'm tracking. I need a minimum amount of trucks every day, depending on the day of the week. Right now I am using nested "IF" statements checked against a cell that has the date in it to pull trucks needed number. I have two questions. First I want to be able to shift...

I have the following formula enter in to "A2": =SUBSTITUTE( (SUBSTITUTE( ("$GR$1"), (1), ("") )), ("$"), ("") ) ; is there a way to make both nested substitutions of "1" and "$" with a single substitute function?

Hi all, Can anyone help me with a formula for the following please? If H1 isn't blank do nothing, if it is then G1, but if G1 AND H1 are blank show "error" Thank you