greater than

  1. B

    Need a formula - filter so 2 columns totalling more than or close to another column only show

    Column I in my excel file shows unpaid invoices. Column K shows uninvoiced items. Column P shows the customer's balance on account . Most of the time, P should be greater than I+K. However we want to be able to easily spot the customer files that are close to or have exceeded the customer's...
  2. D


    I want the last cell in column L that has a number to be green if it is a larger number than cell D11
  3. A

    Help with thrid critera with index match and greater than

    <tbody> D E F G H New Lamp and/or Luminaire Initial Light Output of new End-User Equipment (lm) New Lamp Circuit Power _Watts Coef Factor Remarks 3 E1.1 A LED Lamp only_ELV 1600 2 0.49 ≤5 W=.0.49, ≤10W=0.41...
  4. L

    Greater than and less than using conditional formatting?

    <tbody> Column H Column I Amount 18/19 Costs £90,000.00 £0.00 £10,000.00 £0.00 £123,300.00 £124,000.00 £10,000.00 £10,000.00 </tbody> I need to highlight the above cells as follows: If the amount in Column H is higher than the amount in Column I then the cell needs to be...
  5. S

    SUMIFs with criteria for > Greater & < Less than

    Greetings Experts, I am currently working with SUMIFS and cannot seem to get my criteria to work. U:U Column = # of days the Alert has been opened (0 to infinity) H:H Column = Process Group (Logistics, Supply Chain, Engineering, Fabrication, Assembly) I:I Column = Alert Status (Open/Closed)...
  6. E

    less than greater than for large amount of data

    Hi Guys I am OK with Excel and I know a way that I can do this, using If and AND formulae, but I feel there must be a neater way to do this given the large amount of data I'm working with would make my formula a bit unwieldy. See example data below: <tbody> A B C E F G H I J 1 Type...
  7. H

    Need Formula data based on Multiple text/value conditions

    Hi Team, Can anyone help me with below is the data <tbody> Customer Product Name Amount Contribution by Final Status Cust1 Product 1 17,991 Team 1 Cust2 Product 2 19,901 Team 2 Cust3 Product 3 18,948 Team 3 Cust3 Product 3 10,730 Team 1 Cust5 Product 5...
  8. P

    VB routine to produce message box if value greater then another

    Hi All I'm new to the site. Hopefully I have posted this properly! In the file I'm working in, there are a series of cell into which the user can enter a value of their choice. These cells are all independent of each other so the value are also separate and independent of each other. I...
  9. N

    If either of two cells falls between 0 and 90, then WJ

    At some point I will be able to help more than asking for help. I'm trying to get it so the selected cell will display "WJ" if cell Z2 or AA2 has a number greater than 0 but less than 90. So far I have not been successful at getting it to work. You all are so knowledgeable that it's probably as...
  10. M

    Pivot table groups a buch of date into greater than

    I have a pivot table that seems to be gathering a bunch of dates into a greater than field. I've had this before but its usually just todays date that's the greater than value but this one is >05/09/2017 so theres nearly 2 weeks of data bundled into this value. I've tried refreshing the data...
  11. R

    If Greater, Equal or Less Than Formula

    Hi, I am trying to get a cell to show me the following: If cell AI2 is greater than O2 say "OVER" in cell A2 If cell AI2 is less than O2 say "ACTIVE" in cell A2 Or, if cell AI2 is equal to O2 say "CLOSED" in cell A2 I am currently using the formula...
  12. J

    Index Match - Multiple Criteria with Great Than

    Hi, In this scenario, I need a formula to return a specific value based on (1) a criteria with an exact match, and (2) a range criteria where there is not always an exact match. Table 1 contains the criteria of the lookup (Year and Number), as well as the value I want the formula to return...
  13. A

    Conditional formatting not working on VALUE

    I am working with an exported spreadsheet from an application. I also copied and pasted to a new sheet as text only, but problem still occurs. When I highlight the column range of c2:c100 and set the cell highlight to fill in values greater than 19 (>19) The results are that the cell shading...
  14. A

    Conditional Formatting, 1 Column greater than the other

    Hi all, I'm doing some analysis of data from two measurement systems, I want to see if the two processes are getting results within 10% of the allowed tolerance. The below link is what I'm dealing with in excel. Imgur: The most awesome images on the Internet I'd like to use conditional...
  15. H

    Challenging Formula: Please Help

    Hi All, I have a challenging formula I am trying to create. It essentially incorporates a threshold on profitability. Below I've laid out a simplified version of the data I am working with to help illustrate my problem. <colgroup><col><col span="2"><col><col span="6"></colgroup><tbody>...
  16. A

    Comparing Times in Access

    I'm working on an employee schedule. I have folks start and end times as well as break and lunch times. I'm trying to create 1/0 for working/not working in 15-minute intervals throughout the day. My equation looks to say if the interval is less that the person's start time, greater than the...
  17. G

    Greater but less than formula

    Need guidance to how to make this formula read = 0 and Less than 5.00 but greater than -5 so -5><5 Also is there a way to have it label the ones summing to 0 "Zero" and label the ones less than 5 but greater than-5 "Less 5" =ROUND(SUMIFS([Amount],[Financial Complex],[@[Financial Complex]]),2)=0
  18. G

    If/then with > sign

    Hi folks! Hoping your Friday is going well! Today's question is: Under the total column, I want an if/then statement to provide the greater of the two columns, 25. Can someone help me with this please? <tbody> A B Total 25 15 =formula to give me 25 </tbody> Thank you so much!
  19. A

    Nested SUMIFS with named range > named range is it possible?

    Hi - I have thousands of rows of data and I want to get the difference between the GTE Amount and the LY Award amount, but ONLY where the GTE Amount is greater than the LY Award. I'm using all named ranges. I get a value returned but it's not correct. Can I not do this with named ranges for...
  20. P

    Assigning values to quartiles for multiple data sets

    Good afternoon, I'm trying to build an equation that will assign a particular value to a data set depending on if that value is <, between, or > than a certain value. Disregard flows for now, that will be coming from a separate spreadsheet. The remaining five categories are all on one...

Some videos you may like

This Week's Hot Topics