and formulas

  1. N

    Same formula - different result in other workbook

    I have created formula to determine if a date falls is between two dates. The formula looks like this (in a Table): =AND([@CalcDatesMerged]>EOMONTH(TODAY();-14);[@CalcDatesMerged]<=EOMONTH(TODAY();-1)) I tested the formula in a dummy workbook and the result was like I expected it to be...
  2. S

    Easiest Way to Return #s within 2

    Trying to evaluate 4 groups (columns of data), and formula only return results that are within 2 (+/- 2) of others in a group. Answer should just be 8 - 20, but AND formula returning 1 - 27 instead. Any ideas on how to fix the formula? I'm not sure how to show a picture of the doc, but posted...
  3. E


    Hi, Can anyone help with the correct format for using MEDIAN IF and (I THINK) AND formulas? Essentially i want to calculate the median based on multiple 'if' statements. I can get it to work for one 'if' but not any more... {=MEDIAN(IF(A1="10" ............ , $AD:$AD))} How do i add more IF...
  4. C

    Formulas in Conditional formatting

    I am trying to build conditional formatting for a report I run daily. There are certain criteria that I want to "pop" out drawing immediate attention. I want build it so that the variables in column O (several) are true column W (several) are true and Column if Blank =AND($O1="BR- PAP New...
  5. J

    SUMIFS + AND Formula

    Hello - I have the following SUMIFS formula that I am trying to incorporate an AND statement. My current formula is: =SUMIFS(B27:B1000,X27:X1000,"Active",X27:X1000,"Transfer") I am trying to add an AND statment into this formula which would say AND IF AR ≠ blank, do not include the value...
  6. S

    Help with And and lookup formula

    :confused::confused: I have 3 columns of data. My criteria is this; if there is a number in column A that is within +/-10 of a value in cell in the same column A AND if there is a number in column B that is within +/-10 of a value in cell in the same column B AND if there is a number in...
  7. J

    Multiple if problem

    Excel 2003 Current formula =IF(B6<=80,B8+J3,IF(B6>80<161,B8+J4,IF(B6>160<241,B8+J5))) I need the object cell to display the sum of B6 and one of the 3 conditions, which ever one is correct. All I can get is FALSE.
  8. J

    What IF's

    <TABLE style="WIDTH: 428pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=568 border=0 x:str><COLGROUP><COL style="WIDTH: 60pt; mso-width-source: userset; mso-width-alt: 2925" width=80><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2706" span=4 width=74><COL...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...