nested "if statements"

I have a spreadsheet that allows the user to input different employee/bonus combinations and based on the combination, I have assigned a number 1-4. For instance: A = 1 A+B = 2 A+C = 3 A*B = 4 I created a large nested IF statement to account for every combination, but I have two combinations...

This may not be possible but is there a way to combine these two fomulas together into 1? =IFERROR(VLOOKUP(W2,'[REMOVE.xlsx]Bad Data'!$A:$C,3,0),"") =IF(X2=0,"REMOVE","")

Hi, thank you for reading. What I am looking for is a formula like If B18 Contains Apple, then I18 = "$6000" if B18 contains Essential, then I18=$12000" if B18 contains Access then I18 = "22000" Can something like that work? I just need it to find one word in a large paragraph of text. Oh...

Hi I'm having an issue with a nested IF formula. This is the formula i'm trying to use =IF(BI2=over_600,"0",IF(BI2=450_600,"1",IF(BI2=301_450,"2",IF(BI2=151_300,"3",IF(BI2=51_150,"4",IF(BI2=0_50,"5","0")))))) There are 7 variables and their corresponding scores(): Blank Cells (0), over_600...

Hi I feel like this is probably a bit must to ask but lets see - i have 3 pieces of data for Income / Debt / Credit. For the purpose of this A1 = Income, B1 = Debt and C1 = Credit i need to create a % score based on 4 variable produced by those bits of data. IF B1+C1 = A1 "0%" IF B1 + C1...

Hi all, I have been working on a dashboard which will, dependent on a yes/no indicator, require updates from a given user. The dependent variable is in column B, with about 2000 rows. These cells have drop downs with two choices: "No Changes" and "Update Result". "No Changes" is the...

Hi guys, Please explain me what am I doing wrong with the following situation: I have two tables, in both tables I have sim card numbers and according contact addresses. The reason why I need two tables is that in one of those tables, addresses are more fresh but the problem is that not every...

<tbody> MDT Date Next MDT Was MDT Met? Days Over Due 03/31/17 06/30/17 N 02/28/17 05/10/17 Y </tbody> First formula or conditional formatting is to create a formula that will turn the entire row red if the following conditions exist: 1. Column C is a "N" 2. Column B is past today's...

Hi everyone, okay I'm stumped and I'm getting lost in "IF" statements. I feel like I'm making things so complicated. Let me try and explain. This excel file lists units in an apartment building. I need to indicate if the unit is VACANT or AVAILABLE. <tbody> A B C D E F 1 Today's date...

Hi all, I hope you can help me. I am trying to get a yes / no value in the current conditions. I need to get a yes if the date (H2) is 8 months or over and equal to or under 12 months of the date(F2)and a no if the date (H2) is over 12 months. I currently have this on the go but I'm getting...

Hi guys, I am producing a milestone view based on a variety of columns containing dates and this then plots out milestones based on the results...

I have three columns: E: ContainsL F: ContainsR G: Match ContainsL: =MATCH("*"&LEFT(B2,5)&"*",C2,0) ContainsR: =MATCH("*"&RIGHT(B2,5)&"*",C2,0) Match: =IF(E2+F2=2,"Yes", IF(E2+F2=1,"Yes","No")) ----------------------------------------------------- ContainsL and ContainsR returns either a "1"...

Hi, Can someone please help me to create a nested if? Basically, I want to check if a cell contains a string, and if not, check if it contains another string and so on. My cell is A2. If A2 contains the word "bracelet", A10 = "bracelet" If A2 contains the word "necklace", A10 = "necklace" If...

To Whom it Concerns, I've got 3 different tables for 3 different firms, I've created 3 IF statements which each select a value if the value is below a certain amount it multiplies it by the lowest value in the table; if not it will multiply it by the highest value. The issue is each IF...

I have tried various types of searches to get the help I need, but it either doesn't exist or, more likely, I am not using the correct language to search. I'm not sure this is something that can be done with a formula. I'm not opposed to VBA, but prefer a formula. Essentially I feel like I need...

Hi everyone. I would be grateful if you could help with the two questions below. <tbody data-remaining-comments-count="0" data-canpost="true" data-cansee="false" data-comments-unavailable="false" data-addlink-disabled="false" style="margin: 0px; padding: 0px; border: 0px;"> 1) If I had two...

i have a certain reimbursement rate for certain zip codes. There are 2 levels, rural and super rural. Each has its own rate of reimbursement. For instance, Rural is 284.75, while super rural is 349.10-for one particular service (A0426) Part of the problem is that there are different...

=IF(C8<>10," ",IF(H8=$L$1, " ","FALSE")) I want to make a formula that if c8 =10 and H8= L1, then Error. how do I make this code to work like that? Thanks you

=IF(Acct=Hide_Only,IF(VLOOKUP(F4&$B$13,$Y$13:$AF$429,IF($Z$11=$B$6,2,IF($B$6=$AA$11,3,IF($B$6=$AB$11,4,5))),FALSE)<d3,d3,vlookup(f4&$b$13,$y$13:$ac$429,if($z$11=$b$6,2,if($b$6=$aa$11,3,if($b$6=$ab$11,4,5))),false)),vlookup(f4&$b$13,$y$13:$ac$429,if($z$11=$b$6,2,if($b$6=$aa$11,3,if($b$6=$ab$11,4,5...

Hello, I'm by no means an expert in Excel, but I usually can get by. However, I am trying to figure out the best / easiest way to insert the insurance company based off the Date in Column A and the Loss Type in Column V. I would like the result (the insurance company) to go in Column U) Here...