nested

Hi all, Since learning about IF functions, I was successful in writing a nested IF changing 50 values for a different (but similar) 50 values. Is there a better way that you could direct me to research please. Thank you.

Hi all I’ve been trying to do a formula to pull information fromthis table but I keep getting an error. My formula is: =if(=COUNTIFS('25.2.19'!A:A,A4,'25.2.19'!$D:$D, $D$3, '25.2.19'!$F:$F, “Best offer”), <today)< font=""></today)<> But I keep getting an error. What I’m trying to do is a...

Here is my nested IF statement. For some reason it has an issue when cells in column "J" are "Injector" and cells in column "M" are blank. Not sure why the IF statement isn't working on these cells. I'm telling it to look in column "N" for a date if the cell in column "J" is "Injector" so it...

Hi all, I have a problem with a nested if formula where what I need is a number to appear i a column depending on the numbers founds in another column. I think I have something wrong in the formula because it does not work like that. If someone could help me it would be much appreciated. The...

Hi What is the best way to get rid of numbers in the column below? I only want "John" name to appear without numbers. I can do Find/Replace, or use nested Substitute() but has to be nested. Is there better way to do that? Thank you very much <colgroup><col width="64" style="width:48pt">...

Hi All, I am trying to use the NVD database JSON files (available to download from https://nvd.nist.gov/vuln/data-feeds - ) so I can construct a sheet of all the vulnerailities and then I can sort them in Excel. Yes, I realise that NVD does offer a search function so I could limit it to Oracle...

Hello all and thank you in advance for any advice. Microsoft 2016 I have dates listed in and based on how far away the date is from today in decimal forum I need to add 2 cells together. As an example, if the item x is 6 months from now, I need to add a cell to the price shown therefore...

Hi, I have 2 conditions in two cells and I need these conditions to be combined in one cell, below are the conditions: =IF($X$5="Global",SUMIFS(Galaxy_Data!$T$2:$T$471,Galaxy_Data!$E$2:$E$471,'It would take'!$X$5,Galaxy_Data!$B$2:$B$471,'It would...

I always have trouble with nested IF AND formulas. Trying to figure out how to combine the two formulas below based on whether a number falls between these two sets of numbers: <tbody> A B 1 11 13 2 23 25 </tbody> =IF(AND(N$3>=$A$1,N$3<=$B$1),"PY last 3","") and...

I need to create a nested if statement as a custom column using the Month column (3 letter abbreviation) to create a an integer for each month like below. How would I create this nested if statement? Jan = 1 Feb= 2 Mar = 3 May = 4 Jun = 5

I need some help with a formula (see tables below). What I need is for the Reference ID in the first table to lookup the Reference ID in the second table, and if the date range for that Reference ID in the first table falls inside one the date ranges within the second table, the price needs to...

I am trying to compare a date against NOW() and AND it with a statys field (Complete or In progress), depending on the result a priority field is populated. What am I doing wrong with the statement??? =IF(((AND(NOW()<>E5,F5="Complete")), "NONE", "HIGH"), IF((AND(NOW()<E5,F5="In progress"))...

I have been trying to have a nested IF statement based on the year. It seems like the year portion is causing the issue but I cannot seem how to fix this, I am trying to have multiple years on the same sheet but have a formula to pull up by the year I select. SAMPLE FORMULA: IF(A1="2019"...

Hi Guys, Just found this forum so hoping you can help! I have a pivot table with the following nested IF statement in the calculated field section but it only appears to be picking up the >20% part and the *8% bit at the end...any ideas why? Thanks <tbody> Bonus =IF('% Margin'<0,0,IF('%...

I can't get a nested if statement to work. Using Excel 2010 on Windows 10 This my current working formula: =IF(Q4="SML STND",2.41, IF(Q4="LRG STND",IF(R4<=1,3.19,IF(R4<=2,4.71,4.71+(ROUNDUP(R4,0)-2)*0.38)), IF(Q4="SPL OVER",IF(R4<=90,137.32,137.32+(ROUNDUP(R4,0)-90)*0.91), IF(Q4="LRG...

I can seem to get the formula syntax to get this right IF (A1 <>"" and B1<>"" and C1<>"") Then "Bronze" IF (A1 <>"" and B1<>"" and C1<>"" and D1<>"" and E1<>"") Then "Silver" IF (A1 <>"" and B1<>"" and C1<>"" and D1<>"" and E1<>"" and F1<>"" and G1<>"") Then "Gold"

Hi Guys, can anyone tell me what's wrong with the following construction, please? All three components work individually so I assume it's the way I have put them together that's the problem. In the below, only the first component works...

Hi, I am having a problem writing a nested IF with a VLOOKUP. I have Columns D to O as my table array, with a text string in Col D of which I need to look up "leisure" "business" or "personal". I then need the result of the formula to put which ever of these text options that appear in the...

I am setting up a work schedule and I am trying to create a formula that will check to make sure that each day at least has a day (D) and a grave (G) shift assigned to an employee. If it does not have one of the two shifts, I would like for the missing shift to appear only in row 4. I think I...

Hello all, i cant find why this doesnt work =IF(VLOOKUP(C2,'cost prices'!$B:$J,9,0),VLOOKUP(C2,'cost prices'!$B:$J,9,0),IF(VLOOKUP(C2,'cost prices'!$B:$I,8,0),VLOOKUP(C2,'cost prices'!$B:$I,8,0),IF(VLOOKUP(C2,'cost prices'!$B:$H,7,0),VLOOKUP(C2,'cost prices'!$B:$H,7,0),IF(VLOOKUP(C2,'Kit...