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

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back