nested if statements

I have an array of Date Ranges (Beginning and End Dates in two columns); I need to determine in which "week" a specified resides, and display the Amount (which is held in a third column. I have this formula to do so: =IF(AND(B11 <G36 >F36),K36,0) It works fine for one row in the array of...

Hi all, I'm trying to group data based on volume. I'm grouping as follows:A: >2000 B: 1000-2000 C: 500-999 D: 100-499 E: 1-99 It looks like this: <tbody> Company FY 2017 YTD 2017 YTD 2018 Group ABC Company 40 12 12 E DEF Company 0 0 0 F GHI Company 2,489 1,136 945 A JKL Company 1,025...

New to the forum (Hello!), please forgive me if I am posting my question(s) incorrectly. I have been working on this all day and have hit a wall. The table that I am building is below: <tbody> A B C D E F G H I J K L M N O P Q R 1 Property Target Price Actual...

I'm using this formula: =IF(D10>29,$D$3,IF(16<d10<29,$d$4,if(d10<16,$d$5))) For the 1st and 3rd 'IF' logic statements, the result is returned correctly. When the second logic statement is met, the result is 'False'. The table shows what I'm trying to do: <tbody> <tbody> DISTRIBUTION...

<eomonth($l6,0)+1),$e6,"")))))[ quote] I am looking at the number of class hours per month across the year, and I have the table set up as such (e.g. 31/01/17, 28/02/17, 30/03/17 in the 3rd row from Q to AB) with the formula in the rows below. The first part of the formula makes the cell blank...

Given a column of random letters, I want to identify sequences of a minimum of 3 consecutive letters from the alphabet. For example, if the following letters are given in a column: a,b,c,x, l,m,n, p,g,m,n,o,p,p,g (series1) or a,b,c, k, l,m,n,p,g,m,n,o,p,p,g (series2), I want to get TRUE for the...

NEED help on how get a sheet to tabulate the following problem and allow for multiple usersso I have a insurance office and use Excel to create a log (although currently we just print it off and fill it in manually) to keep track of Which Customer Service Rep's (CSR) turn it is to quote AND with...

Hello, I have the following data in cells: 1 1.12.1.1.2 1.12.1.1.3 1.12.1.1.4 1.12.1.1.4.8 1.12.1.1.5 1.12.1.1.6 1.12.1.1.7 1.12.1.1.8 1.12.1.1.9 1.12.1.1.9.9 1.12.1.1.10 1.12.1.1.10.8 1.12.1.2 1.12.2 1.12.2.1 1.12.3 1.12.3.1 1.12.3.1.1.4 1.12.3.1.1.10 1.12.3.1.2.4 1.12.3.1.3 1.12.3.1.3.1...

We have an Excel spreadsheet where we log in actions taken on certain service tickets. This so-called “Master Data” log is a required SOX control, so accuracy is very important. I wrote a series of nested IF statements using the following logic. At the top of the hierarchy are the elements...

EDIT: I just figured it out. I don't know why I was having such a brain fart, but I just used a nested If statement to check whether the number was above 0. There are only 5 columns, so it wasn't bad at all. I guess I'm just curious now...are there any other cool excel functions to do this...

I have a column for base cost (dollars). A second column has values of "Yes" or "No", where "Yes" has a value of $3 and "No" has no value. A third column has values of "Yes" or "No" , where "Yes" has a value of $2 and "No" has no value. In the fourth column I have to calculate the total cost...

Hello and thanks in advance for your help. I'm attempting to summarize the output from a poorly designed online survey that contains 170 columns (really). Is there a nested IF statement that will output into one of four phrases: "Safe", "At Risk", "Both", or "Not Indicated"? One of several...

Can anyone tell me where I'm going wrong on this formula? As the first IF statement, it calculates, but nesting causes the cell to think the formula is a giant string of text. I'm trying to calculate different percentages based on options chosen on a list (C15 cell). I thought I had it set...

<tbody> The following is sample data: The first column is the original data: The second column is what I am getting when I use the formula in the third column. The fourth column is what I would like to get. I thought I understood nested iFs, but I am missing something. Thanks! 719 S ABERDEEN ST...

I've tried to look at every example of multiple/nested IF statements to see if I could figure this out - as I know it's staring me right in the face. :eeek: I've tried AND, OR - and just can't get it to work. Here's the basic issue - simply trying to find out the average number of days that a...

I'm doing a large set of nested IF/AND statements that isn't working correctly. It's supposed to check if both a user ID is the same as one in the cells 10 rows away, and if the sum of 10 cells in a column is equal to 10. If it is, it subtracts some timestamps. If it isn't, it's supposed to...

This will be an easy one for someone out there. I need a formula that will evaluate 3 combinations of 2 variables (Sales and Employees) and lookup the correct classification. Tried using Nested IFs but it got very confusing very quickly for me! For example: <tbody> Sales Employees...

Hi I've run into a bit of a challenge with dates. Essentially I'm have a bi-monthly calendar with date ranges appearing every two months for a 12 month period. I have two tabs, the first (tab A) contains all the date ranges and an entry for a specific date that doesn't correspond to the range...

Hi All, I hope someone will be able to assist with expanding the following VBA. I found this on a thread in one of these forum and it works great in changing the colour of my pivot bar chart However I need to expand this to take in account the following. I would like to change the colour of...

Using Excel 2010 First and most importantly, I need to auto populate a spreadsheet representing a full year / 365 days from a data set. Secondly, if a specific data item changes, whether the amount changes or the payment day changes, I need it to automatically update the spreadsheet through...