nested if

  1. E

    Excel 2010-What method to use to identify info missing or in error?

    Hello Excel Gurus! Thanks to anyone who can point me in the right direction. I have been tasked to create a "smart" data collection form in excel 2010 where a user inputs collected info from a call. The form is divided into 5 main sections with as few as 6 and as many as 26 manually input...
  2. M

    Calculating a status based on date and a Y/N Value in a seperate cell

    Hi, </SPAN> I am trying to work out the status of something based on a date, while first checking a column to see if something is complete.</SPAN> =IF(L6>$L$4,"Pending","Expired") – This is in cell M6</SPAN> L6 contains todays date</SPAN> L4 contains the date a piece of work was due to be...
  3. M

    How to write error into formula bar

    Hi, I'm looking to write a nested IF formula which will be dependant on certain cells that have errors in them (because those error cells have a formula in them which can't formulate becuase the numbers needed for that formula haven't been entered yet). For example. Cell A1=#DIV/0!. Cell...
  4. P

    Show different values based on the result using nested IF and VLOOKUP formula

    <tbody> A B C 1 clothes transportation drinks 2 pants car coffee 3 shirt train tea 4 sweater bicycle juice 5 tie plane milk </tbody> Hello everyone, I have been trying so had to make this work. I want to return "category 1" if the text is found in...
  5. J

    Help regarding IF statement based on text and consecutive dates

    I have been working on a spreadsheet on excel 2010 tracking the number of items a student can acquire. One student can have multiple teachers (uID). Items can be tested once or multiple times in a day. From columns A to E lists the raw data while column G contains filtered data of unique items...
  6. L

    Index/Match from NestedIf

    Can I use Index/Match to correlate a value given from a nested if formula? For example. AW15 contains...
  7. 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...
  8. R

    Nested If, Multiple Nested If, IsError

    Hello, I'm stuck here. Column G is people's names, columns I and J are dates, the formula I’m writing is in column R. My desired end result is: If column G contains the name “Ed”, column R should say “N/A”. However, if column G contains a name that is NOT "Ed" AND there are dates in...
  9. N

    Nested If and Functions

    Hi All I have a spreadsheet with 2000 rows of information, What i am trying to do check the Numbers column if the cell values match and set the first time of call to 0 i:e the 0 to represent the initial call and then work out the time difference between additional calls in the time bucket...
  10. Z

    Nested IF formula

    Hi all, I'm using Excel 2013 and I need a nested formula in a column of my worksheet but I just can't get around the right syntax. I need the formula to do the following: IF G4 = "TOR" and Q4 = "TO", THEN "Correct", else "Wrong" IF G4 = "DMCR" and Q4 = "DMC", THEN "Correct", else "Wrong" IF G4...
  11. S

    Vlookup giving a 0 for a blank cell, should I use an IF statment?

    Hello, I want cells that are >=6 to be have a "P" instead in a different worksheet 3-5 to have a "F" instead in a different worksheet <=2 to have a "G" instead in a different worksheet But in my worksheet I have 0 and blank cells. I need the 0 to say "G" and the blanks to remain blank. I...
  12. E

    need help including =EDATE in a nested if statement

    i have a formula that i want to increase the typed in date by a week, month, or year, but am having trouble putting in the "edate function my formula is as follows: =IF(F8="WEEKLY",I8+6,=IF(F8="MONTHLY",I8+30,=IF(F8="YEARLY",I8+365,""))) i want to replace the +30, and the +365 with and edate...
  13. B

    Conditional formatting with Nested If Statement utilising Dates

    Hi All I am trying to produce a Resource plan which shows projects in Column A, then has 5 Stages for each project which contain a Project start date then at lest 3 items of data (Stage Lead (Name), Stage Finish Date, and Stage Resource). I need to create something akin to a horizontal stacked...
  14. D

    IF AND, IF OR Sum Complex Formula Help

    Hello All, Looking for help with a formula. I have attached a sample data set (see below 4 rows) and will spell out the logic I hope to obtain. I can include further information if it is not clear what's trying to be accomplished. I have 4 validating criteria that have been provided weights. I...
  15. S

    Nested if statements

    I just can't seem to get this right. I have two conditions, Balance Days Action >$1500 >1200 "Keep" >$1500 <1200 "Remove" <$1500 >840 "Keep" <$1500 <840...
  16. M

    excel 2010: nested 'if' as the 'value if:false' argument

    hi all here's the situation: a) if(client limit>x;if(utilization>client limit;calculation1;0)) b) if(client limit<x;if(utilization>x;calculation2;0)) i've tried to nest b) into a), in place of the value if: false (0) argument without success. i dont have any VBA skills, so would prefer to use...
  17. P

    Checking for #N/A value in nested IF statement

    Hello! I'm using a nested IF statement and calculating values based on the data in adjacent cells. I basically want part of my formula to do this check: If this cell isn't equal to #N/A, then display a certain value. Right now, my formula looks like this...
  18. J

    Nested IF statements and the INDIRECT function in XL2010

    Hi, I am having a few issues with the excel autofill function. Here is what I want it to look like: <tbody> A A1 =IF(Sheet2!A1>=4,100,IF(Sheet2!A1=3,75,IF(Sheet2!A1=2, 50, IF(Sheet2!A1=1,25)))) A2 =-A1 A3 =IF(Sheet2!A2>=4,100,IF(Sheet2!A2=3,75,IF(Sheet2!A2=2, 50, IF(Sheet2!A2=1,25))))...
  19. C

    Strange results for nested IF after data refresh

    Hello all - I have an odd situation - making it even odder is the fact that a google search doesn't produce a million people having the same problem. I have a calculated column with the following formula to identify outliers in contract values...
  20. B

    Embedded formulas

    I've got an interesting one that I hope someone can help me with. I have a spreadsheet with two drop-down lists and two cells to fill in and this populates data in a table so that a journal entry can be entered into the accounting software. The drop-down lists consist of the following: 1. Type...

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 MrExcel.com.
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 "mrexcel.com".
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
Back
Top