# nested if statement

1. ### IF, AND, VLOOKUP help

Hello, I am trying to do a If And with a vlookup within the same workbook. IF(AND(IF(AF3431="Red",VLOOKUP(AG3431,'VLookup Table'!E:F,2,FALSE),IF(AF3431="Blue",VLOOKUP(AG3431,'VLookup Table'!E:F,2,FALSE),IF(AF3431="Green",VLOOKUP(AG3431,'VLookup...
2. ### If Statment within an if statement

So I am having trouble with my if statement. My logical test is if G19>40, If its true I want it be F19-(G19-40), however if F19-(G19-40) is a less than 0(or negative), then it needs to read"0" if false f18. HELP!
3. ### What is wrong with my nested IF statement?

I am tring to have people exter a number between 1 & 4 in a cell in column E and have this in the cells in column F to display the corsponding text that goes with the number they entered. Excel keeps saying the function is wrong and I can't seem to be able to figure out what it is I am doing...
4. ### Complicated Nested If statement with 12 conditions and left function

Hello profs., I am having a long table containing about 20,000 rows (format is in numbers having 15 characters long), I need to get only the first 6 digits in the left for each number and then need to do an if statement with 12 conditions so to map each code with its correspondent company name...
5. ### Formatting of multiple nested IF(AND... statements help

I am attempting to deliver a pricing model (matrix). The model is dependent on the number of average transactions (x-axis) and the number of overall customer. As pricing increases, the incremental cost decreases (i.e. the incremental cost at 5,000 is less than that at 1,000). I have created...
6. ### Wildcard and Nested IF Statements

In Excel 2013, I'm trying to create a nested IF statement using wildcards. I have data similar to the following: PC Unit Account CMCPX 21002400 GOOD CMOPX 21002400 BAD CMOPX 70021160 GOOD CMCPX 70021178 BAD CMOPX 70021186 GOOD CMCPX 21001599 GOOD CMOPX 21003601 BAD When "PC Unit" = "CMCPX"...
7. ### "You've entered too many arguments for this function." Nesting IF statements

I am BRAND NEW to the forum so any help is very much desired. I am trying to figure out what I did wrong on the following equation: =IF(Refi!\$C\$2>Proforma!L3, SUMIF('1st Mort'!\$B\$17:\$B\$256,Proforma!L3,'1st Mort'!\$E\$17:\$E\$256)+SUMIF('1st Mort'!\$B\$17:\$B\$256,Proforma!L3,'1st...
8. ### nested if function

Hi I am having a bit of trouble with my nested if statement. I seem to have got most the way. I am trying to say if one cell is less than 11 and another cell is less than 6, return yes, otherwise no. I am using the formula =IF(M2>11,yes,IF(I2<6,"yes","no")) Which works until I get a...
9. ### Help!!! Nested IF Statement limitation

Greetings, I have a nested IF statement that I am using in an application I am building in Excel. I am using logic to get the current month and then evaluate whether the value is a number. I would like to know if there is a better way to perform what I am trying to accomplish using another...
10. ### Nesting multiple IF functions with a VLOOKUP

Greetings all, Long time troller, first time poster. I'm building a spreadsheet that tracks total product packaging weight by multiplying packaging weight per unit by the number of units sold. e.g. 10grams of HDPE per unit x 1000 units sold = 10kg of HDPE. I have a large worksheet with all...
11. ### Need the right Nested IF formula for this condition

Hi all, Cell K2 is my Date of Arrival, Cell L2 is my Date of Departure. I need to a formula in cell M2 that will do the following: if K2 < or = TODAY AND L2 > or = TODAY, then it outputs "In House"; if K2 > TODAY, then it outputs "Not Yet Arrived"; if L3 < TODAY, then it outputs "Departed"...
12. ### Nested if statement with vlookup + conditions

HELLO Excel Experts! Goal = Return a value "0" if cell value is blank or "1" if value matches same one on other sheet. I feel I'm close but can't figure this out. I think I need if statement to set conditions of "1" TRUE or "0" FALSE & vlookup to match values on two different worksheets. I...
13. ### Compounding Commission Schedule

Hi All, I'm very new to this forum so please forgive me. I'm trying to create a compounding commission schedule that is as follows: 10% of the amount from \$0 - \$50,000 with a minimum of \$1,000 5% of the amount from \$50,001 – \$100,000 3% of the amount from \$100,001 - \$250,000 2% of the...
14. ### Return a blank cell based on criteria

OK The formula in C4 under PRICE is =IF(ISBLANK(B4),"",IF(A4="I",150,IF(A4="T",120,IF(A4="S",75,)))) and the formula in E4 under NEW COST is =IF(D4="D",C4*0.8,IF(D4="SD",C4-60,"")) What I want to do is have the cost under Price disappear if there is an amount under NEW COST. <TABLE...
15. ### Sticky If statments

Afternoon,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> This one has been giving me nightmares, (Literary) all month.<o:p></o:p> <o:p></o:p> It is an IF statement which users ranges and arguments. I have similar, which works without...
16. ### Nested if (again .. Sorry)

Good Afternoon Ladies and Gents (Excel 2003 (XP) user) trying to nest up a few IF Formulas into one equation IF(AND(B56=FALSE,B57=FALSE,B58=FALSE), “TICK PRICING OPTIONS”, “ ”)<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>...
17. ### Nested "IF" Function Help???

Hi Folks, I'm having a problem with a formula that has a series of "Nested IF" functions in it. Everything works fine, UNTIL I add the LAST "IF" function, then Excel 2003 returns, "The formula you typed contains an error" and highlights the second "AND" in the formula. Here's the formula in...
18. ### Nested if statement!

Thank you in advance for all your help! I am looking for the correct setup of a nested if statement with 4-5 arguments if sales reach a certain thershold 1% bounus if sales increase 5% - 10% = 2% bonus if sales increase 11%-15% = 3% bonus and if sales increase 15% = 4% bonus Thanks...