nested "if statements"

Hi, I have a complicated nestled If string which isn't working - does anyone know why? =(IF(OR(((F6-I7)>O3),((F6-I7)<K3)),(IF((F6-I7)=(AB5:AB247)),(((F6-I7)-K7)-1)),((F6-I7)-K7),(IF((F6-I7)=(AB5:AB247)),((F6-I7)-1),(F6-I7)))) Logic: Find if (F6-I7) is greater than O3 or smaller than K3 Do...

Hi Folks, I' am struggling with the below formulas. Please can anyone help? I have column U and column V with values. If column U is the same as V, I need it to return text Ok. If both cells are 0, I also need my formula cell to return the text Ok. If cell U is greater than U, I need my formula...

I am using a nested IF formula with multiple conditions that looks at two cells (D7 and C7). See below: =IF(AND(D7=100%,C7=100%),5,IF(AND((D7=100%),AND(100%>C7,C7>94%)),4,IF(AND(D7=100%,C7<95%),3,IF(AND(D7>89%,D7<100%),2,IF(D7<90%,1,0))))) The table that is used to qualify the resulting...

Hi all, I am trying to remove/leave blank the #N/A result of a formula containing two nested IF statements and a Vlookup. The current formula is: =IF(A2<>"",IF(A2<>"JOHNSMITH",VLOOKUP(A2,'Sheet1'!$A$2:$AH$143152,34,FALSE),""),"") I've tried placing an IFERROR before the entire formula as...

Good Evening everyone! Thank you for taking the time to read and possibly reply. I need to update an IF formula (I didn't create it) and nest it with another IF formula, I have been looking and trying for a few hours and haven't made any progress. Because of the way the formula was created and...

I have searched for this question but have not found an answer that works for my scenario. I have range J2:S2 that have flags (I'm just using the letter "x"). I need my formula to tell me if the range contains multiple x's (Multi), a single x (Single) or blank (blank). I was able to...

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

Hello! and thank you for helping me find a solution to this problem. Right now I have a very long nested function that has around 200 if statements and left functions. The function works great, but I can only go as far as 64. The purpose of this function is to get part of a string in a cell and...

Excel & VBA Folks, I'm fairly new to VBA, but have been working hard to learn & help my company. I need help consolidating my code though, it's long & continually tests IF statements. The below code runs through about 1500 rows trying to match trade breaks to two seperate spreadsheets depending...

HELP? This is my first post so please let me know if I can clarify what I'm trying to learn to do. I think in SQL they call this a SUM TILL. I think I figured out how to do it with nested IF statements but there has got to be a better way with INDEX, INDIRECT, MATCH, or OFFSET (maybe in an...

Hello all, I'm Trying to insert a line of code into a sheet's cell when a command button is pressed. I have three text boxes;tbMaterial, tbQty and tbCost. There a some materials that we use regularly so I already have their price listed (Ref_Cost). Other materials prices need to be entered...

Good day all, New to the forum but here goes. I am using Excel 2013. I receive a list of addresses on a daily basis. but the address I receive is only the number of the house. The number determines the community name. example: address 52303-1 belongs in Comanche III community. the "-1"...

Pardon, I know this is rather confusing...I'm just having trouble thinking of how to simplify this and wondered if anyone had any ideas they'd care to share. I started writing a formula recently with a bunch of nested IF statements that's kind of spiraled out of control. I'm wondering if anyone...

An Excel spreadsheet currently exists which has several years worth of data. In the past, exclusion codes were eight characters in length and they were always at the end of the comment. The previous formula worked fine before the exclusion codes were changed and the method of entering the...

I have spent literally over 4 hours trying to figure this out. Please, if you can help. SO, my boss wants me to have in a cell if someone makes less than or equal to 300000 then times another cell by 20% but at minimum the answer must be 25000 and in the same cell, if the person makes more...

I want to build a formula that sums a column based on criteria that is greater than a certain number. I've tried nesting a formula, however, I'm doing something wrong. Basically I want to choose criteria from "Column A" where the value is ">4", and sum the data in "Column B" into cell "D2". This...

HI, I have a question card with 5 questions 1,2,3,4,5 going down column A1, A2, A3, A4, A5. I would like to work out the percentage of the score where the answers can be from 1-5 in column B next to its respective question number. BUT the questions can also be answered 0 if not applicable and i...

Guys n' Gals, My Excel is seriously rusty and i'm a little a bit at a loss as to how to deal with the problem below. I have 2 columns of data as outlined below, which depending on which rules they meet they are categorized as per the table below (see Example data) There are a set of rules...

I'm using a nested If/And formula with 13 different logical tests. Basically, I'm trying to get an age value displayed when I enter a date of birth into cell B3. Of the 13 logical tests, I have 3 that span a number of years and then the other 10 are only covering one year. When I input the...

Hi everyone, Im trying to create a tracker that displays the current grade of my class to the main dashboard along with the progression number which is determined from the predicted grade to the current grade. say they were predicted an A and the current grade was a B the progress would be -1...