nested if statements

Many many thanks in advance for what I've been told by other users, will be a big sucess in asking you experts for help! So needless to say I'm a first timer here on Mr. Excel. What I need to do is return a value from a table based upon 3 variables. Variable 1 has 2 options, Variable 2 has 4...

I have inherited a formula from an ex-colleague that contains approximately 14 nested IF statements. I have read somewhere today that you cannot use more than 7. I am using Excel 2002 and I would be grateful if someone could tell me how I can adjust the formula to ensure that it works...

Hi Guys, Any chance someone could look at this nested IF statement and see what the problem is. I have spent hours on it but it just doesn't seem to work. Thanks in advance, =IF(I18<49,7, IF(I18=50-100,11, IF(I18=101-150,12.5, IF(I18=151-501,I18/100*14, IF(I18=502-1001,I18/100*12...

I see answers to problems using 'case' , I think this is exactly what I need , but I don't know how to set it up and the syntax, does the case have numeric values or can they be text. I'm hoping to avoid nested if's , maybe even nested ifs within nested ifs

So I have done a few of these formulas in large tabular data sets for conversion into power pivot. I did this fine doing z-score using averageifs and my own stdev formula using ifs to check against names/data types as I wanted. Anyway ... I wanted to also get the first difference of the set...

I was making good progress with this, but seem to have run into a roadblock now and can really use some help. I am trying to make it so that I have a drop-down menu that will have data based off of what is in cells B6 and C6. Cell B6 will have two options (in a drop-down); "Minot AFB" and "91...

Hi I need help on writing this formula, never posted here but I am hoping someone can help. I have a model with changing payroll data and have made a tab of forecasted cumulative payroll. I want to forecast the different payroll taxes a business will incur in 2013. For example FUTA tax is only...

Hi there, First posting here -- this forum has been a huge help in the past! A1 = constant B1 = ever increasing sumifs based on daily web query & between certain dates C1 = if(B1<=A1,sumifs(based on daily web query & between certain dates), <leave the="" c1="" value="" that="" existed=""...

I have a fairly large spreadsheet with about 5,000 lines and 100+ columns. I've taken a small piece of it and posted below to give you the layout of the spreadsheet. Row 2 is a number assigned to each month over the next 10 years. What I'm trying to do is write a formula that will look...

Hey Guys, Need a bit of help again, I need to create a report that will look at the time that a group of people are logged in and then based off of how long they were staffed, tell me how many minutes they should be in break and lunch. Ex. If an employee is logged in for 2Hrs 10min they get...

I am struggling with a formula with a 3 x nested IF statements. The error is "Too many arguments" when there are only 3. I might have a bracket wrong, but doesn't appear to be. Help please. Formula is...

Gday all, I've been trying my hand at writing a macro to compile data from two separate sheets, I've gotten a lot of more simple stuff to work but the macro i've created to copy selective rows of data into a new sheet seems to do nothing. I figure i've probably got some usage/ syntax way off...

I need to summarize data from 4 sheets in a workbook into one master sheet within the same workbook. The 4 sheets represent different employees and the data are the accounts they are responsible for spread over 12 months. There's a billed, paid and difference row. The summary sheet needs to...

I need some help with constructing a formula. This is what I have: =IF((AND(G22="Strong Positive",I22="Positive")),"Moved Up",(IF((AND(G22="Strong Positive",I22="New")),"New Report"),(IF((AND(G22="Positive",I22="Promising")),"Moved Up",(IF((AND(G22="Promising",I22="Caution")),"Moved...

I have BSU's that share a prefix in this format- 7HP, 7AP, and have some letters after that for different departments. Then I have indepenedent departments with no client prefix in this format- 2HO, 1HO,ZHO, etc. I want to make an IF statement with multiple wildcards, something like...