less than

Hi friends, the other day, someone posted an issue on the web asking why the statement "i < ActiveSheet.Rows.Count" returns False, in which the variable "i" is declared as a String and is assigned an integer value 3. I have been thinking about this problem for two days and still can't figure out...

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

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

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

Hi, sorry of this is confusing. Let me use an example to clarify. I am making up a solution, e.g., 146ml. However I only own 50ml tubes, therefore the calculations used to make up the original would need to be altered so I could use multiple of my tubes. In this case I would make 4 x 37ml...

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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