greater than

  1. W

    If range of cells greater than and less than X

    =IF(A2:A11>=50&A2:A11<=59,"*","") The formula above gives me "#VALUE!" I am trying to get a "*" if A2:A11 have any number that is in the range between 50-59. So, if A6 (or any other cell) has 50 (or any other number up to 59), as shown below, I would get a "*" as a sign. Please help, thank...
  2. M


    I am really struggling with the formulas for one particular cell. What i'm looking for is the value in B17 will be determined as Followed. I'm hoping someone can help my brain wrap around this IF b15 is less than 50, then b19= "Product A" IF b15 is greater than 50, and less than 250, then b19=...
  3. E

    Greater than, Less than, In Between

    I am having trouble trying to format a column that displays a text depending upon whether the column next to it is greater than, less than, or in between a certain value. More particularly, something like this, #<2 it should display "Short" #>2.5 it should display "Long" 2<#<2.5 it should...
  4. W

    IF function greater and less than

    Hello, community I would like to ask for your help, i have a column that has random numbers from 1 to 12 and the format is Time (7:05). In an another column i try to create an if statement =IF(E2<3,RANDBETWEEN(4,8),IF(AND(E2>3,E2<8),RANDBETWEEN(30,40),RANDBETWEEN(8,14))), thus, if it is below...
  5. B

    Find First Value in Column Which is Greater Than Specified Value (Searching from Last Value in Column)

    I'm trying to find the first value in a column which is greater than a specified number (searching from the bottom of the column). Once that is found, I need it to return data (a date) from a corresponding cell. Because of the dataset, the search must start at the bottom of the column. I've...
  6. L

    Using the IF Function within Excel

    I am trying to work out a calculation within Excel and my values for 'arg' can lie anywhere between -10 and +10. Within a cell, I would like to work out how to use the IF Function to say: If the value of 'arg' is greater than +1, then the value will be changed to +1. If the value is less than...
  7. 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...
  8. 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
  9. 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...
  10. 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...
  11. 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)...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. 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...

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