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

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

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top