greater than

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

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

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

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

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

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

I want the last cell in column L that has a number to be green if it is a larger number than cell D11

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

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

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

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

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

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

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

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

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