nested if

Ref. screenshot: Imgur: The most awesome images on the Internet Here is the formula in question: Let me try to how it works, and how it should work:- I want our marketing department to insert the blue fields "marketing", and then i want the rows in column "K" ("forecast from" - "forecast to"...

Hello, Looking for a solution to Column K2:K126 contains different text search for a string (_X1 or _N1 or _S1, or _A10) X = Hawk N = Sparrow S = Eagle A = Owl What i am wanting to do is, if(K2:K31 has _X1 return value Hawk or if (K2:K31) has _N1 then return value Sparrow etc was looking at...

Hi , I am getting an error message in excel with this formula. Can you please help. 1st its looking to see if it is a duplicate row and returning 0 if so 2 its looking to see what quarter the order falls in and if the end date is after the quarter then return 100000 else 0. thanks, Sharon...

I have these data which all contain boolean value. All cells from AR3 to BC3 is boolean. Every line works independently. But I cannot seems to get it to work if nested together. It gives error of too many argument. IF(AND(AR3,AS3,AT3,AU3,AV3,AW3,AX3,AY3,AZ3,BA3,BB3,BC3),"Construct...

I'm attempting to use VBA in place of a nested-If formula (see end of post for original formula that works); I'm comparing two columns and depending on their values, assign a test outcome (four outcomes: true|false + positive|negative). I'm attempting to use CASE instead of IF, but I'm running...

Hello, I have a 3 column data table with cost centers [CC], transaction codes [TC], and dollar amounts [AMT] and I am trying to calculate the difference between debits [TC = 081] and credits [TC = 010] for each cost center. I put the cost centers in column F and used the formula below. I used...

I am trying to create a project rollup cell based on the values of the values of the subtasks under the main task. The formula I'm using is: =IF(ISTEXT(MATCH("Need Help",$F3:$F7)),"Need Help",IF(MATCH("Some Issues",$F3:$F7),"Some Issues",IF(MATCH("On Track",$F3:$F7),"WTF?"))) My data set...

I have a nested IF Statement that if a single cell has one at of information. For example: =IF(A1="YES", IF(AND(B2="OLD",B3="DOG"),"OLD DOG",""), IF(A1="NO", IF(AND(B2="YOUNG","CAT"),"YOUNG CAT",""),)) The formula isn't that simple but it gives the basic premise of what my issue is. My issue...

Greetings all, Let's say I work at a company that builds machines with different model numbers. The most basic machine we build has 2 components. The most advanced has 6. Of these two most advanced types, we have 2 categories, A and B, so we make a super fancy A and a super fancy B. The store...

Hello! I need help with this formula. Right now this formula is true if all the values in red are E, 1, N or all the values in blue are E, 1, N Sometimes my data base wont have data in red or blue, and sometimes will have both. When it has data in red and blue i want my formula to consider the...

I have cells that contain a citation which includes a date (e.g., 2013, 2014, or 2015). I'd like to search the cell and have the formula report which year is present in the cell. This is the formula I was trying to use, but it doesn't seem to be working: =IF(SEARCH("2013", C2) "2013"...

Hi guys! Marcelo Branco gave an excellent answer to another user on here at this thread of which I am using the formula. However, I need to take it one step further: I need to nest two IF statements to my current formula...

I have a list of employee working in our company with expiry dates of their national ID. I already tried a nested if statement and its giving two output Expired and Valid. My one issue is that when it reaches to an empty cell its says "Expired", even though I'm expecting it to be empty also...

Hello everyone, I'm trying to structure a rule within conditional formatting that will be responsive to start and end dates of construction projects and to change the color of a cell that falls within those dates. To clarify, I have the following structure in my spreadsheet: - A top row with...

Hi there, I am working with a spreadsheet that deals with construction costs that is giving me trouble. In this spreadsheet, I am given the total cost of construction as well as the start and end date for the project. My goal is to approximate (on a monthly basis) what the total spend per...

I am looking for a better way to sum values from multiple tables located on a different worksheet.I am using a series of IF statements but soon will run into the nested IF limitation as I need to expand the summary table to include many more tables located on the other worksheet called Engine...

*sorry if duplicate post, browser crashed and I didn't see that it had posted but on the off chance it did apologies* Dear all, First off, thank you in advance to anyone who posts an answer to this question - I really appreciate your help! I am using Excel 2007 to try and make a spreadsheet...

Hi, i have some data of no of calls and i am trying to seggreage them based on the number of minutes spent on them, i am using nested if condition but it is giving me problems can somebody help. <tbody> 146...

Hi! First post! And also incredibly difficult! I am creating a formula that changes the content of a cell based on the current date. I have 2 tabs. The first tab with have the cell that contains the formula I am having difficulty with and the second tab contains a table with all the data...

Hi All, I am in the final stages of building a formula based, 24hour (15 min interval) Gantt chart, within my workbook I am struggling with one formula, as follows: I am entering this formula into Cell N5 If C5=Blank, then E5 Otherwise C5, If E5=Blank, then G5 Otherwise E5, If G5=Blank, then...