# less than

1. ### 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...
2. ### countif cell contains less than 6 characters, or contains digits

How do I count a cell if it contains less than 5 characters, or contains digits (even if mixed with letters)? After data transfer, I have a list - some are email addresses, some usernames, some random text. I want to filter these to username which are less than 6 characters (for example) so us...
3. ### Row height change if less than....

Is there a way to get a row to resize if it is below acertain height? I have my rows in a range set to 38 but I have them autofitting once the day is entered in case the row needs to be taller. Is there a way for this to either only resize if it is goingto make it taller OR after the AUTOFIT...
4. ### 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. ### Help with 3-level Conditional formatting + fill down

Hello and thank you for the help J3=215, J4=214 and so on to J93 N3=215 and conditional formatting for this cell has 3 rules Cell Value < J3 (green format) applies to =\$N\$3:\$N\$5 Cell Value = J3 (yellow format) applies to =\$N\$3:\$N\$5 Cell Value > J3 (red format) applies to =\$N\$3:\$N\$5 The...
6. ### Array to pull two adjacent cells values based on date

After much scouring of the threads I have found nothing similar enough to this that I can steal from. I am trying to pull Space and Manifold ID from a chart on a separate sheet based on the date the manifolds were repaired on. The manifolds and space repeat a lot as there are multiple valves...
7. ### Formula for date error checking if a certain date is greater than another

Hi all, I work in a business where we have a date driven process. As happens with all data, however, sometimes entry errors happen. I want a formula that will check to make sure that the second record date (AE) is not greater than the first record date (AC). However, when I write the formula...
8. ### 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)...
9. ### 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...
10. ### Conditional Formating

Hello - I am looking to conditionally format, in a pivot table, a cell based on whether it is more or less than the month before. Sounds simple enough, right? Wrong (at least for me)! My dataset lists the item in rows, the months in columns, and the sum of quantity in the values. I want to...
11. ### 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...
12. ### 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...
13. ### 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...
14. ### 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...
15. ### Using a COUNTIFS formula with a less-than criteria

Below is the table I am working with. The "Call Sequence" column is just a continuous list of Calls (1 to 2221). There are 11 different call types with 11 corresponding Prefixes. Because there are many calls of the same Call Type I would like to count them. I also want to have the "Suffix"...
16. ### How to set multiple criteria for .advancedfilter in VBA

Hello All, I am trying to use the xlfiltercopy action with the .advancedfilter function in vba to filter through some data and copy it to another sheet. The criteria for the filter, however, will be all values between two variable values that will change on every iteration of the filter, i.e a...
17. ### Combine countifs with match for greater than or less than values

I need to count up all the machines that are less than 181 days old and older than 149 days. I can do this with sumifs, but not countifs. The sumifs formula I used that worked is below. I just need a count and not a sum...
18. ### VBA Conditional formatting help

This is the code that I have for conditional formatting. What I want to happen is as follows Cells that contain numbers between 0 and 1 to be red Cells that contain numbers greater than 1 and less than 100 to be yellow Cells that contain numbers equal to 100 to be green Here's the current code...
19. ### indirect and > or <

i am setting up a report where the user can set certain inputs. These are then used to highlight entries in a report. How can i get something like indirect to bring each of the values from the input cells into my report? as an example: A1=6 A2=< A3=8 I can get the value for a1 and the value...
20. ### Formula to Count Data in a Range That is Consecutively Outside of a Specification

Hello all, I am trying to create a single formula in a single cell that lists the number of times an out of specification condition occurs for greater than two hours. As an example: Time Temp 0:00 -15 0:15 -15 0:30 -16 0:45 -16 1:00 -17 1:15 -18 1:30 -20 1:45 -20 2:00...

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