nested if

  1. B

    If formula in excel

    If a1=u, a1=t, a1=v, a1=x and a1=y, then b1=z. How can i use the logic in excel formula?
  2. S

    SUMIFS with nested if within criteria ... or something else?

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

    Sumifs or nested ands

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

    If with 3 conditions and 3 possible answers

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

    Nested IF statements with a Search function

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

    Nested Ifs referencing different cells

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

    Multiple vlookups in a nested if statement

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

    Strange If And Or issue

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

    If Statement - If false, then check next cell

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

    Nested IF Returning "FALSE"

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

    IF formula with multiple conditions - can't fix it

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

    Evaluate a range and return rightmost result (nested if?!)

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

    Help with Sum based on criteria that is a mix of text and numerals

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

    Code not returning data i want

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

    Issue with Nested If_need help

    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'...
  16. R

    Help Nested and or IF Function

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

    Conditional Formatting with nested IF, OR & AND

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

    Trouble with nested IF equation

    =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= " ", "...
  19. B

    nested if and search and move help

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

    Nested IF statement with 18 IFs

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top