nested "if statements"

I need a little help with what I thought would be a prettysimple if function; however, the solution seems to allude me. I have 3 columns. Column H is going to generate text (“Yes”or “No”) based on what’s in columns I and J. Columns I and J are for dates someone is certified in aparticular...

Hi! I'm still learning to use nested formulas, and I'm trying to divide this particular formulate below by 7, but when I put /7 the output is incorrect (in this case the sum is 24 but the output of when I put /7 I get 20 - which is definitely not right). Please help...

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

I did find a thread that came close to my solution... but not quite :-\ I have two columns K and L. If L is blank use the value of K. That worked out just fine with: =IF(L40="", K40,L40) My question is how to add an additional condition of: IF K40 is also blank THEN type "Unassigned". It...

I am currently trying to construct a table of raw materials that will automatically adjust based on information entered about productions. The system currently consists of 3 excel sheets: 1. A general ledge of all finished product stock in and out. This consists of columns for date, product...

I am creating a bid estimating sheet. It is derived from a pricing sheet from a supplier. The estimater, will pick the materials (B1,B9,B13,B), " SS304X4, Galv, Cold Rolled, Tube" from a list. The selection will generate another list from gauges or diameter available per product. For each...

Hi, I have a number of nested IF formulas that aren't working and I feel like I've tried every variation but still can't craack it! Any help would be gratefully received! SO in the cell next to the formula, I have 3 options and depending on what is selected, I then want it to generate a...

Hello - Excel is telling me that I have an error with this formula. Does anyone have an idea of what it might be, and why? Thank you very much...

I am hoping to find assistance with a formula that will help me identify which requisitions have been fully or partially awarded. Each requisition may have multiple lines and none, some, or all of the lines might be awarded. In the example below Requisition 111111 has three line items, but...

Hello all - I would be very grateful for any help with the following: A very helpful board member, jtakw, helped put together the following...

First off, this is my first time posting, so sorry if I'm missing any important guidelines or formatting! I've been working on a small tool at work that I'm trying to make as turnkey as possible. I'm attempting to use the SUMPRODUCT function to parse my data by two separate custom lists I've...

Hello everyone - I would love some help with this formula if someone is willing to give it a go: =IF(BG2="RT",IF(AND($AR2="x",$AZ2="L",$J3<= $BF2),"Y",IF(BG2="RT",IF(AND($AR2="x",$AZ2="S",$I3>= $BF2),"Y",IF(BG2="T",IF(AND($AR2="x",$AZ2="L",$J3<=...

I have 2 spreadsheets. One is the Master, the other is called Export. I need to get the numbers from the export into the master (column C) each month based on the item row name and the IDs in column A need to match. I kept trying: IF column B CONTAINS this, then pull in column T from other...

So I am trying to factor in production rates and want to return a percentage based on that rate. The problem is the goal rate varies depending on data in two columns (equipment used, container type). Column 1 could be: None Yes-Deaerator Yes- RP Filter Yes- Both Column 2 could be: Tote Fluid...

I'm trying to nest multiple IF statements, along with IF(AND(OR) statements within one cell. The "Premium Table" I have to use is below, along with a sample of the the worksheet. The question is: What IF statement do I enter in cell D2 to obtain the correct premium? Premium Table Age Range -...

I am trying to join two datasets (csv format) by using conditional if statements. First dataset is accident information which does have a unique id (caseno) and the second dataset is roadway information which does not have a unique id. To join the accident file to the road file, I have to match...

I had excell 2007 and i upgrade to 2016. everything was working fine with 2007 and also excell 365 i have this nesting and how i can change to be able to used with excell 2016 =(IF(G3="STORAGE 1",".666666666",(IF(G3="STORAGE 2",".80",(IF(G3="TRANSPORTATION",".80",(IF(G3="STORAGE...

I have a workbook where I input information in specific cells to create combinations to calculate employee bonuses. My workbook has 4 tabs: Data Bonus Base Bonus Summary The Data tab is formatted like this: <tbody> Column A Column B Column C IF formula below Base Salary? Employee...