less than

  1. 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...
    • LiamHems
    • Thread
    • excel greater than if funcitons if function less than
    • Replies: 3
    • Forum: Excel Questions
  2. angeloudaki

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

    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. 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...
    • Lesjoan01
    • Thread
    • amount column conditional formatting greater than less than
    • Replies: 13
    • Forum: Excel Questions
  5. M

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

    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...
    • Nade85
    • Thread
    • array date index array less than manifold1
    • Replies: 1
    • Forum: Excel Questions
  7. N

    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...
    • Nathag
    • Thread
    • date formatting greater than date if statement excel less than
    • Replies: 3
    • Forum: Excel Questions
  8. 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)...
  9. 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...
  10. B

    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...
    • bethi
    • Thread
    • conditional formating less than more than pivot table qty
    • Replies: 4
    • Forum: Excel Questions
  11. 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...
    • Nanaia
    • Thread
    • cell greater than less than multiple cell reference
    • Replies: 3
    • Forum: Excel Questions
  12. 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...
    • RYANE
    • Thread
    • cell equal greater than if cell less than
    • Replies: 3
    • Forum: Excel Questions
  13. 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...
  14. 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...
    • pg101a
    • Thread
    • equation withing equation greater than investment analysis less than percentile
    • Replies: 0
    • Forum: Excel Questions
  15. N

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

    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...
    • dorian821
    • Thread
    • .advancedfilter greater than less than multiple criteria
    • Replies: 3
    • Forum: Excel Questions
  17. M

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

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

    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...
    • ajm
    • Thread
    • greater than indirect less than
    • Replies: 2
    • Forum: Excel Questions
  20. T

    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...
    • templetonjp
    • Thread
    • countif countifs between times countifs; array frequency function less than
    • Replies: 10
    • Forum: Excel Questions

Watch MrExcel Video

Learn Excel - Add Mean to Bell Curve - Podcast #1825

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