# and formulas

1. ### 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. ### 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. ### MEDIAN IF (and AND?) FORMULA

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

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