and formulas

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

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

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

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

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

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

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.

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