**[Solved] DEBUGGING: Nested drop down in an IF stmt using data validat** *Summary*: Hello! I'm trying to get the following formula to function.. and as it's setup the final [false] parameter keeps showing up, as IF it's ignoring the r...

**Excel nested If statements** *Summary*: I am unfamiliar with "complex" formulas in Excel. I am trying to create a nested if statement that has 11 possible results. my original data is nume...

**[Solved] nested if statement problem, if blank then 0 or blank** *Summary*: I am working with a nested statement - if n2=y, then apply this and if n2=n apply this, but there will be some cells in the n column that will be blan...

**[Solved] please i need the ans** *Summary*: what is the general syntax of nested loop? ...

**[Solved] Excel Greater Than/Less Than Nested IF** *Summary*: I need to capture the following: If data is >= 3.65, return 3 If data is < 3.65 but >= 3.35, return 2 If data is < 3.35 but >= 3.20, return 1 If...

**[Solved] is a Nested IF statement the answer?** *Summary*: I am trying to create a formula that would tell me in cell J5 the highest grade acheived in G5, H5 & I5 example G5 H5 I5 J5 A ...

**[Solved] I can't get this nested if statement to work Excel 2007** *Summary*: What is wrong with my nested if statement? =IF(A8<30000,((A8-30000)*.0%),(IF(30000<A8>90000,(A8-30000)*0.5%,((IF(90000<A8>150000,(A8-90000)*1...

**[Solved] Nested IF statement with words not values** *Summary*: Hi, I am having some problems with the best way to make my problem work. I think I will need a nested if statement but, nothing I have been able to f...

**[Solved] Nested IF AND syntax if a condition cell has a value** *Summary*: Hi, I've read the excellent post on nested IF AND syntax, but I have one thing I can't solve. Scenario: If cell A1 contains either "Value1" or "Value2...

**[Solved] Nested if returning false** *Summary*: I am using a nested if statement to determine the date and amount of an investment. The function works in the affirmative but returns false otherwise...

**[Solved] trouble with nested formula** *Summary*: I am looking to have a formula that says if Cell W44 = "Niche" then perform the following calculation V44/20*12 and /or if cell W44 = "PWM" then then ...

**[Solved] Nested IF Statements Excel 2010** *Summary*: I'm having trouble creating a nested if statement. I have to figure out how much bonus money is paid out to an employee based on their pay grade. Pay ...

**Nested Delayed Expansion Variables in Batch** *Summary*: Hello, I'm writing a batch file to pull in information from two files - one that contains computer names and one that contains ip addresses. I want to...

**Nested If Statement, Ranges?** *Summary*: I'm making a spreadsheet to track whether course prerequisites are being met by the recommended course sequence at the university where I work. What I...

**Nested if problem** *Summary*: Hi, I have written two different types of nested if statement. One which has more arguments/conditions returns an empty cell which is what it should ...

**Nested IF statement** *Summary*: Hello, I have to make a table with the holiday plans for all our employees. On one side you enter the days for the vacations, on the other side there ...

**IF statement. Dates with different outcomes** *Summary*: I am trying to extract some data on dates to a dashboard to present it in a pie chart. I have a list of dates relating to when something was tested. ...

**Nested IF Statements** *Summary*: Background: I have two validation lists with possible values in Excel. The first list has a number of values. I'm only interested in one value- X. The...

**How to do a nested FOR loop? ** *Summary*: Here's my goal: 1) grab name1 in LIST.TXT, which is a text file with 20 computer names. 2) Find the computer on the network, go to Logfile.txt and f...