nested if

I have a report showing the monthly breakout of departmental expenditures with many fields (account, department, project code, program, etc). On another tab, there are mini charts for each account code represented within the report. Each mini chart has a number of criteria it looks for on the...

Good morning: I work for a trucking company and have several years worth of load & payroll data. The data is contained in 2 tables. Table 1 columns are: date, truck, driver, load, miles Table 2 columns are: week start, week end, driver, cost. Each driver can do...

Hi, guys First, excuse me for my english. I hope you guys understand what I mean. I have the following data and conditions: A1 = 7 B1 = 2 C1 = 9 (the answer would be 7) A1 = 0 B1 = 5 C1 = 3 (the answer would be 5) A1 = 0 B1 = 0 C1 = 4 (the answer would be 4) A1 = 0 B1 = 0 C1 = 0 (the answer...

Hello All, I am hoping that someone can help me with this formula. It seems to breach when I add additional SEARCH functions in a nested IF statement. When I added the last criteria to find the word "Reclass" I get a #Value Error YES the source cell is TEXT. I did check it. YES the word...

<tbody> A B C D E F 1 Allocated Budget Spend Forecast Spend Total Spend (inc. Forecast) Max Budget (Overspend) Budget RAG 2 £100 £50 £25 £75 £110 </tbody> Can anyone help correct my formula please? I basically want to work out a single formula to use in F2 for the following rules...

I am trying to take a list of Product Numbers in Table 1 and put a Type description next to it based on which column the item number appears in a separate table. I can get the separate IF/Vlookup statements to work individually, but not all together. Formula I'm using that doesn't work...

Hey all, getting N/A errors for some reason. =IF(AND(OR(J255="Closed",J255="Auto-closed"),C255=1,NETWORKDAYS(D255,O255)<=17),"OnTime",<o:p></o:p> IF(AND(OR(J255="Closed",J255="Auto-closed"),C255=2,NETWORKDAYS(D255,O255)<=17),"OnTime",<o:p></o:p>...

I'm creating a function that needs to find if a name in one cell (E3) matches a name in a list of cells. I have two formulas I've tried to use but neither is quite right. Formula 1 could work, but it'll take forever to write all of the nested if statements (and it would be difficult to add new...

I am trying to create a spreadsheet so that users can change start month from drop down list, for example if they choose June all months prior to June will read as 0 and all the months after (including June) will have the recurring value. I have tried to accomplish this with a nested IF formula...

Hi! I am having troubles with an IF formula with multiple conditions. This one works fine : =ROUND(IF(AND([@[Distribution JJ]]="noos - first fill",[@[Distribution 760]]="noos - first fill",[@[Distribution BST]]="noos - first fill",[@[Distribution ONS]]="NOOS - FIRST FILL"),([@[Total bought...

Hi there, I currently use an IF formula to evaluate two cells, and return the data in the 1st cell if there is nothing in the 2nd, and the 2nd cell if it is populated; =IF(B1="",(A1),(B1)) Now I would like to do this across an array of cells, i.e. I would like the rightmost cell in a range to...

I have a situation where I have 4 contract types and many clients have multiple contract types. I have created a spreadsheet with a "switchboard" so I can select the contract types I want to include in my sales estimates using "TRUE" or "FALSE". I can also set a percentage threshold based on...

ActiveCell.FormulaR1C1 = _ "=IF(AND(RC[2]=""DUCK,DONALD"", RC[2]=""RABBIT,ROGER"",RC[2]=""MOUSE,MINNIE"",RC[2]=""DUCK,DAISY"",RC[12]=""WHITE,SNOW"",RC[2]=""DOE, JOHN"",RC[2]=""DOE, JANE""), ""DUCK,DONALD"",""DOO, SCOOBY"")" The above code should bring back DUCK,DONALD but is bringing...

Hi, My issue is little weird. I am using the following formula in my excel. Each of these two if blocks, separately, works fine. However, when I combine then, excel only works on the first block. In this case, if a text has "$", it will work perfectly, but in other case it will throw '#value'...

who knows how to do this?https://ibb.co/fx8Lhw

Hi everyone. I am trying to format a cell based on a couple of conditions. $N13= formatted when1. $C13="CharterB" OR "CharterKP" AND 2. $F13 < 04:00 OR $F13 > 22:00 This is what I have tried, but it is formatting everything with $C13= CharterB or CharterKP and not just when the hours = those...

=IF(Z700=1, "st", IF(Z700=2, "nd", IF(Z700=3, "rd", IF(Z700>3, "th")))) I have this equation in Col AA. It refers to the previous column. It's working fine except that when Col Z has a blank it still returns th in Col AA. I've tried adding things like IF(Z700 is blank, " ") or IF(Z700= " ", "...

Hi Excel geniuses I am trying to sort my movies I have and I have them listed with a marker at the end of the file either [720p] or [1080p] or nothing I have used these formulas to move the resolution tag to the front so I can group movies by resolution. I used these serpeatly to move the...

I am trying to figure a better method than using a Nested IF statement with 18 IFs. The below example is only 3 IFs, but my data has 18 columns of amounts. I have to assign an Account_No based on if there is a value in an Amount column. I couldn't figure out how to use VLOOKUP for this. Not...

Hello! Here is my formula.. =IF($A$2>DATE(2017,MONTH(L$3&"/1")+1,1),0,($D78-L76+L77)) A2 = today's date Column D = stock L76 = monthly forecast L77 = deliveries due in month L78 contains the above formula & as is referred to as the 'availability' So basically if the month is in the past the...