Nested Related Problems & Solutions

19 tags
Refine Tags

Start a discussion

Results 1 - 19 of 19
[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...

1


Ask Question