nested if

Hello! Here is my formula.. =IF($A$2>DATE(2017,MONTH(L$3&"/1")+1,1),0,($D78-L76+L77)) A2 = today's date Column D = stock L76 = monthly forecast L77 = deliveries due in month L78 contains the above formula & as is referred to as the 'availability' So basically if the month is in the past the...

Hi, I have a formula that checks to see if a value in one column exists in another column on a different sheet. =IF(ISERROR(VLOOKUP(A2,stephanie!A:A, 1, FALSE)),FALSE,"stephanie" ) I want to check additional sheets (potentially many) such as sue, bob, mary, etc. if the value isn't found in...

<tbody> A B C D E F G H ROW 2 X 19 23 45 18 ROW 3 Y 99 103 100 123 88 ROW 4 Z 987 1001 1020 888 </tbody> I am trying to populate column H, using data from the bolded columns. What the formula is supposed to do is compare C2 and D2 and provided they are not both blank, it needs to...

Hi, I hope you can help.. I have a simple formula where if AP6 cell =0 then I need the formula to return blank then proceed to the regular formula, but its not working.. Please help. Sharon <tbody> =IF(AP6=0,"",IF(R6>Q6,"CHECK","")) </tbody><colgroup><col></colgroup> <tbody>...

The formula below is in a lengthy macro and it worked fine when the nested countif range uses numbers, i.e. countif(P6:P1000); I need a dynamic range however, and I've been trying to replace the range numbers with different versions of " & LstRw " but all I get is syntax errors. I assume I'm...

Hello all, I have this formula that doesn't seem to be doing what I want: =IF(C12>=KDS!D6,KDS!D6-C12,IF(C12<=KDS!D4,((KDS!D4-C12)*2)+KDS!D5-KDS!D4,IF(C12<=KDS!D5,KDS!D5-C12,0))) C12 has a value of 3:51. D4 is 3:52 D5 is 4:04 D6 is 4:14 What the formula is supposed to do is if C12 is lower...

I need to make two macro buttons that increases and decreases, respectively, the value of a cell based upon it's decimal value. For example: Cell AA8 currently = 117.292 IF the 3 digits after the decimal point (Right 3) = 317 then add 0.683 to the cell. IF above is false then check if last digit...

I am having difficulties with creating a formula. AS will look at AP if AP=PRIME it will use table 1 B4:B8&C4:C8 it will then look at AJ4 to determine where that number falls within the table to determine the value to return in range f4:f8. If the value in AP=OFF it will use table 2...

I have a nested IF statement that I need to expand if a new column is added which happens often. Wondering if there is a better way to handle this? Here's my formula =IF($A$4=$D$4,$D7,IF($A$4=$E$4,$E7,IF($A$4=$F$4,$F7))) If works perfectly, except I will be adding a column G next month and...

Hey All, I am looking to design an IF statement that is pretty complicated. I've tried doing this with no success so far so I'm reaching out for help. Here is what I need it to say: If H2 is not Blank AND P2 Is Between 13-54 Then Category 1 Else If H2 is not Blank AND P2 Is Between 55-95 OR...

Hi there I cannot seem to figure this out for the life of me. I am getting a Div0 error with the following formula and cannot figure out how to get rid of it. Does anyone have any ideas? <tbody> </tbody> <colgroup><col span="5"><col></colgroup><tbody> </tbody> <tbody>...

Hello, First and foremost, sorry if the title is confusing. I've been writing and staring at formulas so long words make little sense now. :stickouttounge: I work at a call center and am trying to write a formula for a workbook and am having some difficulty. Scenario: The work book has 11...

Hi all, I have designed quite a complicated nested if statement that carries out different calculations depending on whether certain fields are blank or not. I have 30 columns and I have renamed each with reference to the time point I am referring to (e.g. feas1 feas2 etc - (FEAS referring to...

Hello, Im trying to build a function that will pull one of 4 possible dates from a table. Ive managed to build a formula that will pull through 2 dates but i cannot figure out how to add the other 2 dates. I have four columns which may or may not have a date in them. These dates are in a...

Hi, Need a formula for showing value of a cell as follows: if cell value = value in cell a1, then show value in cell b1, else if cell value = value in cell a2, then show value in cell b2, else if cell value = value in cell a3, then show value in cell b3 and so on. <tbody> Value (input) A B...

I have 2 spreadsheets one that is retrieving data from a database (Vlookupdata) and the second spreadsheet (Filter workbook) I want to use to retrieve data from the first workbook. I want the second workbook to retrieve data based on the value in the List in cell B1. The data in the first...

Here is what I am trying to do: =IF(AA5="","No",IF(AA5<=J5,"Yes","No")) - My lame attempt Upload Days = AA5 (The number of days to acutally complete the project) SLA Days = J5 (The number of days allowed to complete a project) Project Uploaded Date = M5 (The date that the project was...

Here is my equation: =IF((M5="","",IF((NETWORKDAYS.INTL(X5,M5,11,______!$O$4:$O$17))<1),"1",IF((NETWORKDAYS.INTL(X5,M5,11,______!$O$4:$O$17))>=1),(NETWORKDAYS.INTL(X5,M5,11,______!$O$4:$O$17),"False"))) What I am trying to do is as follows: - If Cell M5 is Blank, display "Blank" its an empty...

Given the following snippet of a database: <tbody> sample # XDAT Horiz dy # max dy 1446 211 201.2 98 1447 211 202.2 68 1448 211 203.0 50 1614 200 135 40 1615 200 136 45 1616 200 130 35 </tbody> I would like to automatically fill in the "#" and "max dy" columns as...

I have a list of locations, with their coordinates, and I have a set of regions of which I have the coordinates of the border points. Now I would like excel to specify for me in what region every location is. I was thinking of using a nested IF function, but I have up to 20 regions so I am...