nested

Hey guys, (first time poster!) I'm trying to write a nested IF statements, and I'm not sure if there is an AND or OR statement that should be added to complete the formula. My goal for example: IF D27=x,D28=y, return C9 OR IF D27=x,D28=z, return C10, and so on replacing D27 and D28 with...

I need to compare to columns using index/match but round each value before comparison. Could create a dummy column but that is very cumbersome and ugly. is there a way to perform an operation on each cell value before the comparison =match(round(a6,1),Sheet!A6:A1000) I need...

Hi all, Any ideas why this nested loop is staying on just one row and not pulling down? Thanks in advance - CatLadee r = 1 For intOuter = 1 To intOptions - 1 For intInner = intOuter + 1 To intOptions With Range("Output_Tbl") .Offset(r, 0).Value = intPairs...

I have a nested IF OR formula, but both of the criteria to evaluate has the same result. My formula is: <colgroup><col width="64" style="width: 48pt;"> <tbody> <colgroup><col width="64" style="width: 48pt;"> <col width="76" style="width: 57pt; mso-width-source: userset; mso-width-alt...

Hi I want do check student marks and based on the value I will make excel to type a,b,c,d,f. If >80 then A, if >70 then B etc. I can do that using nested if. But lets say I have 10 conditions, is there better way to do that? if function will be complicated. I wonder if there is something easier...

I've tried so many options but it only seems to return one answer. E.g. The values I have are [A1] 41, [A2] 0.08, [A3] -2 and [A4] -13. In B1 I have: =IF(A1>5,"High",IF(A1<-5,"Low","Mid")) This returns "High", which is correct. But I drag it down into B2, B3, B4 and the cell ref A1 changes to...

I can't seem to get this to work. <=5% = 1 >5% - 10% = 2 11%=3 12%>4 =IF(AND(D3<0.05),1,IF(AND(D3>0.05),2,IF(AND(D>=0.11),3,IF(AND(D3>0.12),4)))) =IF(AND(D3<0.05),1,IF(AND(D3>=0.05),2,IF(AND(D<=0.10),2,IF(AND(D3=0.11),3,IF(AND(D3>=0.12),4)))))

FYI - im working in excel version 1803, office 365, and in swedish. This is my nested IF formula. =IF(AND(ISNUMBER(SEARCH("ICA";D4));D2="STANDARD");ICA_STANDARD; IF(AND(ISNUMBER(SEARCH("COOP";D4));D2="STANDARD");COOP_STANDARD...

<tbody> NAME PRICE PER PACK NO. PER PACK PRICE PER UNIT <tbody> product a 2 x 150ml </tbody> 24 <tbody> product b 3 x 200ml </tbody> 13 <tbody> product c 6 x 300ml </tbody> 64 <tbody> product d 4 x 500ml </tbody> 46 <tbody> product e </tbody> 12...

How do I write the formula for a nested if function if the 3rd condition I want to write is ...,IF(B2=""n"No data"))) which means ...IF(B2 is blank, then show "No data"). My idea for the formula is like this: =IF($A$2<=B2,"Valid",IF($A$2>B2,"Expired",IF(B2="","No data"))) And, the table should...

Hello MrExcellers, How would you create function that takes the parameter to make calculation of nested loops. Specifically the repetition of "for " line reproduced inside function? For ex: for a=1 to 10 for b=1 to 10 for c=1 to 10 for d=1 to 10 'calculations next d next c next b next a as...

I need a nested formula to pull a specific code type in a column. My transaction code field needs to pull AD, FY or RN = (Advances, First Year or Renewals). If the Earned/Advanced column has Advance, this automatically equals AD. If the Earned/Advanced column has Earned, this needs to be FY...

Hello All! I've got a problem with the formula I've made it checks two cells for 2 values and If true returns the value stored on the history tab, which is great when the true value is there, when the cell w4 is blank, then I want the formula to not return anything. Just a blank cell I think...

I need some help with a nested formula. Here is what I need: If cells, C10, C11, C14, C15 are populated then "Ok to save","Not OK to save". All 4 cells need to be filled before it says it is OK to save I appreciate anyone's help. Have a great day! Brian

Dear Mr. Excel: I am a schoolteacher who is trying to create a multiple-choice auto grader. However, I am having difficulty created a nested function. Can you let me know what is wrong with the following?: =IF(ISBLANK(E10),"",ISNUMBER(SEARCH("B",E10)),"1","0") Sincerely, Robert McLeod

I have scoured the Internet and I fell like this equation is correct, but there is something not right. I have three Access Database Queries that cannot be merged and I am using: IF(ISNA(INDEX(InstallQuery!F:F,MATCH('Install Report Week...

I have a formula that is partially working. There are multiple IF statements nested, and the first two actually perform correctly. Once I get into a couple of layers it starts to result in #NAME?. When I click on the various statements within Excel it seems to work through the logic correct...

Hello, I am having an issue with an Nested IF THEN statement. I am hoping you can assist. The formula i have is located in DR4 `=IF(DF4="0","",IF(R4="PC",((S4+1.5)*(T4+1.5)*(U4+1.5)-(S4*T4*U4)),((S4+1.5)*(T4+1.5)*(U4+1.5)-(S4*T4*U4))*V4)/1728*7.48) the goal is to look at DF4 if its zero...

Hi experts I am trying to plot a nested x axis in a stacked or your standard column chart in Power BI and it's turning into a nightmare... I have Turn on responsive under "General" formatting and Turn off "Concatenate labels" under X-Axis.. cannot see the wood for the trees....sample data...

Hi All New to the boards & wondered if you could help me with a challenge: - I have one worksheet showing a pattern of 10 matches weekly football scores. I have another sheet showing all possible combinations of three scores 125,000 possible combinations. I can tell from a simple Countif...