nested if statement

  1. A

    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. M

    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. S

    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. T

    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. C

    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. madkinson

    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. I

    "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. E

    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. T

    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. A

    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. Z

    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. J

    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. C

    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. M

    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. C

    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. D

    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. E

    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. D

    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...

Some videos you may like

This Week's Hot Topics