if formula

  1. R

    IF & COUNTIFS Formula?

    Hi, I'm having trouble working out the below....hoping someone can help. I am working in Two Sheets. Trying to get a formula that does this: Looks for the value of Sheet1 K2, in Sheet2 column B. If that exists, then it looks to see if the balance in Sheet1 J2 is greater or less than the value...
  2. B

    Adding spaces in IF formula

    I am needing to add a few spaces between E3 and J3. Could someone help me modify the formula below. =IF(E3="","",IF(C$3<>"",C$3&"","")&F3&" Rev "&E3)&J3 Thanks for the help
  3. R

    IF formula comparing to numbers, and allowing for rounding

    I have three cells. A20: 38.2 B20: 39.3 C20: contains IF formula to tell me if A1=B1, then "Good", if not, then "Check" To clarify, columns A & B contain numbers with decimals, row 20 would be the sum of all those numbers for each respective column. However, due to decimals, the totals won't...
  4. N

    Time conversion help

    Hi, Hoping Toadstool will see this as he knows the history of what I have been trying to do. But if anyone can help I would be so grateful. I am doing timesheets and have formulas in now that work for adding hours over multiple rows and then multiplying it by 1.5 and 2. What I need now is...
  5. R

    want to see if a range doesn't contains any values other than this

    hi, can't figure this out. I want to create a formula that will check all of column A, to see if it contains any values other than "October". So here's an example: Column A October October March October April In the example above, the formula should return ether "Yes"...
  6. PritishS

    IF(ISNUMBER(SEARCH formula considering 2.5 and 5 as same. How to check for exact match?

    Dear Sir, I have a formula based on which one excel cell changes value based on other cell value. The formula I am using...
  7. V

    Search and return a match from a range with a string of text

    Hi, I need to search for a match between a range of text and strings of data in a table. If a match is found then I wish to return that match into the next column. I have tried this formula =IF(ISNUMBER(SEARCH(Schools,[@Tags])),Schools,"") but it will only return data for cells on the same...
  8. tlc53

    Return cell value if conditions met, without duplications

    Hi, I'm not sure how to use Match with an IF statement, or if it's even possible to do. Here is what I am hoping to achieve; Car Type B14:B23 Tax Treatment E14:E23 Private % F14:F23 Input Data B28:B37 I would like the Input Data B28:B37 to be pre-populated depending on what the Tax...
  9. tlc53

    3x Checkboxes - Hide/Unhide sheet

    Hi there, I have 3x Form Check Boxes. If any of them are ticked, I would like sheet "Dairy" to be visible. If none of them are ticked, sheet "Dairy" should be hidden. I have linked the 3x check box references to cells P1, P2 and P3. In P4 I have the following formula...
  10. R

    index/match formula? comparing 4 columns

    hi, so the workbook is set up like this, with 4 columns: Column A - country code Column B - country name for that code and then you have the same, but not in the same order Column C - country code Column D - country name i need a formula looks at the country code in C2. If C2 is present in...
  11. M

    Formula works, then doesn't

    Hello, I am at a loss as to what is happening here. I have some survey data on one sheet, and I am putting together a summary on another sheet. I want mean, standard deviation of the sample, and median for some of the data. I am compiling the summary statistics both for all surveys and for...
  12. K

    If value in list, then assign label

    Hi All, Good morning/afternoon/evening depending on where you are in the world. I've run into a little problem on this fine Monday morning! I feel like its a really easy one and I'm just being an idiot, or the weekend hasn't quite worn off completely I'm not sure! I've tried looking online and...
  13. tlc53

    IF Formula - Isn't returning Blank when I want

    Hi there, I would like cell D310 to return blank, if cell B310 is blank. Both contain an if formula.. Cell B310 =IF(SUM(F310:G310)<>0,433,"") Cell D310 =IF(N(B310)<>"",FYE_Date,"") In this instance, both cells should be blank but cell D310 is returning the FYE Date. Does anyone have any...
  14. tlc53

    If Formula - Error when I extend Range

    Hi there, I have a basic formula =IF(D181=B268,B181,) This correctly returns "Dairy Foods" However, when I try to extend the range =IF(D181:D182=B268,B181:B182,) It returns #VALUE !, instead of "Dairy Foods". Does anyone know why it's going that? Thank you!
  15. L

    Return cell value if date is between two dates

    <tbody> A B C D E 1 Job Number Date Amount Week 1 Week 2 2 02/03/2019 09/03/2019 3 08/03/2019 15/03/2019 4 201 05/03/2019 3182.20 5 201 05/03/2019 2137.80 6 201 07/03/2019 4349.80 7 201 08/03/2019 2362.80 8 201 11/03/2019...
  16. K

    Vlookup formula that returns multiple answers by searching through multiple worksheets in a single workbook

    Hi, I am trying to determine if I am using the correct type of formula and figure out why I am getting an error with the formula I am using (maybe I should use a different formula completely.. such as an index or some sort of array or a if... IDK). I need to search column C row 1:556, on...
  17. S

    Extracting 1st word of a text string delimited by 1 of 2 characters

    I have strings that I need to pull the first word out of. The problem is, that the first word is either delimited by a space, or an underscore. I have been using the below formula to find the first word if separated by a space, but unclear how to add the OR to look for an underscore...
  18. R

    Using vlookup for multiplication

    Ok two I have two files File 1 Column A Column B Currency FX Rate USD 1.14 EUR 1 JPY 126.77 File 2 Column F Column G Column K Local Currency Local...
  19. N

    IF question

    Hi there, i was hoping someone could help me with this query. i have a large set of address data which needs to be cleansed and analysed to find duplication within rows. i have included a sample set of data which hopefully will portray my issues. Hopefully, someone can help. <tbody> Name...
  20. A

    Multiple AND must be satisfied, formula help please -

    Hello all - I am trying to figure out a way to do the following please, and could use some help: I have the following headers: A1 = TestA, B1= TestA Verified, C1= TestB, D1 = TestB Verified, E1= Time, F1= Time Verified, and finally G1 = All Tests Satisfied, I have a lookup that populates the...

Some videos you may like

This Week's Hot Topics