# greater than

1. ### Excel - greater than value from a range + an additional if

Hi = I've been fumbling around and cannot figure this out. If someone can help, I would really appreciate it. Cell A1= If any % in a moving list (Column M; i.e. the top number will be abs val'd and the list will grow as we pull down) is greater than 50%, then a cell is multiplied by 10%... if...
2. ### Conditional Formatting (CF Rule) Using INDIRECT Function

Hello, I'm having some trouble getting a Conditional Formatting Rule to work using the INDIRECT function. I'm using a formula within the Table for testing in column 'C'. Column 'E' - outside the Table - was converted to use the INDIRECT function to work from outside the Table. Columns A:B...
3. ### Conditional formatting

Hello, I need some help trying to figure out this conditional formatting. I've tried looking at other formulas and implementing them to my situation to no avail. I have the conditional formatting set up as to have anything that is greater than the max ID to go red, however if the max ID cell...
4. ### 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...
5. ### HELP WITH IF THAN GREATER THAN, MULTIPLE SCENARIOS

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=...
6. ### 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...
7. ### 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...
8. ### 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...
9. ### 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...
10. ### 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...
11. ### CONDITIONAL FORMATING LAST CELL IN COLUMN GREEN IF GREATER THAN ANOTHER CELL

I want the last cell in column L that has a number to be green if it is a larger number than cell D11
12. ### 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...
13. ### 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...
14. ### 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)...
15. ### 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...
16. ### Need Formula data based on Multiple text/value conditions

Hi Team, Can anyone help me with below requirement....here 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...
17. ### 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...
18. ### 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...
19. ### 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...
20. ### 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...

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

### Which adblocker are you using?

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

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