nested if

  1. A

    Nested if

    Hi All, In Column G I have customer PO's listed- When Order Entry types in the PO description each person has their own style. I need to identify when the PO field has the term No Charge.. They could type No Charge, NO_Charge, No-Charge, NCSO, NSO, nc..( and others but these are the main ones)...
  2. G

    Countblank and If statements

    =IF(ISBLANK(Q22),"FAIL",COUNTif(C27:Q27)"=>"&$Q$22),IF(COUNTIF(C27:Q27,">"&$O$18),"FAIL","PASS") I think I got myself twisted up here. The idea is to replace one of the Pass/Fail columns on the right with a code that leaves the portion IF(COUNTIF(C27:Q27, ">"&$O$18), "FAIL", "PASS") intact...
  3. J

    Nested IF in Sliding Scale Formula

    Sorry. I know there is a simple solution to this and I’m just blind to it. Calculating Sliding Scale Percentage Current Formula in cell A46 =IF($B$33<5000,”.007”,IF($B$33<10000,”.006”,IF($B$33>9999,”.005”,””)))*10 This works perfect, however I need this formula to consider the value of A43...
  4. D

    Calculating NETWORKDAYS considering leaves and holidays for each employee

    Hi, I have some data where the networkdays to be calculated for each activity. Also, the leaves of each person and the common holidays are to be considered in the calculation. <tbody> Row Col A Col B Col C Col D 1 A B C Common Holiday 2 3-Sep-19 19-Sep-19 16-Sep-19 9-Sep-19 3 13-Sep-19...
  5. M

    HELP with IS BLANK statements

    Hello, I am trying to create a formula that will do; If C2 AND D2 AND E2 contain text (date format) then "READY" else "BLANK" in another cell. If any of the three cells have a date it still needs to show blank, only when all three have a date can it show ready. I have tried various If...
  6. H

    Nested if loop

    Hello, I am relatively new to VBA and am making a tool for work. In this particular part I am trying to pull the correct email from the sheet 'Active Contacts' by first looking for an exact match, then an exact match of the next column over (another contact name), then approximate match in the...
  7. M

    IF with 3 conditions

    Hi I'd like to write a formula that i) checks that J1 is not blank i) checks if the word "for" is NOT in a cell J1 ii) checks if cell K1 is equal to 0. I've tried this formula but it's not returning the result expected. =IF(AND(J1<>"",K1=0,COUNTIF(J1,"*for*")),"Code","Blank") Please...
  8. L

    Nested if statement to look in between multiple date columns to see if tag is applicable based on 1 date

    Hi everyone, I need help writing a nested if statement to solve for the "desired result" column. I need to look in between each of these dates and determine which was most recent to the "comparison date", and display the "desired result" tag. The combinations on this are driving me crazy and I...
  9. K

    Nested If Formula Problem

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

    Nested if

    I am new to excel. I am trying to categorise numbers of employees in groups. In one column I have numer of employees and other has nothing in it and I am writing formula like this in the second column, if the number of employees is less that 10, then write 4-9, if less than 50 then 10-49 etc and...
  11. C

    Nested IF with Vlookups

    Hi, I built a table (PriceTable) that keeps pricing based on volume ordered as follows: ColumnA ColB ColC ColD 1 ProductName Sign Qty Price 2 ProductA > 10 $3 3 ProductA < 10 $4...
  12. S

    Vlookup, Match, Index, Nesting If's....

    I've been trying to figure out the best way to get data based on a current date and typically use vlookup but it won't allow 12 conditional statements to look at each month. I want to populate based on the current date retrieving from tables from each month assuming the table was extended out...
  13. 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?
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. 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>...

Some videos you may like

This Week's Hot Topics

Top