nested if

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

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

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

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

Can I use Index/Match to correlate a value given from a nested if formula? For example. AW15 contains...

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

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

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

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

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

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

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

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

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

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

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

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

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

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

I am trying to create a formula that will assign the quarter of the calendar year from which each month belongs. I have a long list of numeric months (A), and want the output of the formula in (B) to be as follows: A B 1 Q1 12 Q4 3 Q1 5 Q2 etc. I would do a...