greater

Hello, I need help with a simple IF statement: If the value in A2 is between 5 and 10, then I need B2 to equal A2-1, if the value in A2 is greater than 10, then I need B2 to equal A2+1, if the value in A2 is less than 5, then "" in B2

What would the formula be for the following, in using conditional formatting (to determine cell to format). I can't seem to use both in the same rule. I even tried doing them separately in their own rule but no go. Here is my statement ... Greater than 1 (>1) but Less than 10 (<10). Exactly...

Hello, How can i change the formula below to use a range for greater than/less than. I'm trying to say if k137 is equal to or greater than 6.5 but equal to or less than 0.5. =IF(K137>5,IF(AND(D152>=$L$12,D152<=$M$12),$J$12,"-"), "-")

Hello, I need help with a simple IF statement: If the value in A2 is between 5 and 10, then I need B2 to equal A2-1, if the value in A2 is greater than 10, then I need B2 to equal A2+1, if the value in A2 is less than 5, then "" in B2 I appreciate all assistance. Thanks!

Good morning, I have a column with about 4000 numbers. I want to see how many cells in this column have a value greater than .17. Thanks,

Hi all, Hard to explain what I am after. Sheet named Schedule: starting column V row 24: is has numbers that may appear in any row in that column, some are 1 to 100 others are over 100. is there a formula to look into this column, return the first number it finds greater than 100 in the next...

Hi: I have date in C1 - 9/30/18. Range - A2:A100 has dates Range - B2:B100 has numbers I want to return value in B2 if date in A2 is greater than 91 days from 9/30/18 AND less than 180 days from 9/30/18. Could you help please? Thank you very much. Sean

I have inherited a spreadsheet with this array formula: =IFERROR(INDEX(In.Out!BO:BO,SMALL(IF(In.Out!BT:BT=1,ROW(In.Out!BO:BO)-MIN(ROW(In.Out!BO:BO))+1),ROWS(ProgAll!$P$5:P5))),"") I don't know a huge amount about Excel but the formula needs to return values greater than 0.5, not just equal to...

Hello I have distance in my data that I would like to categorise into radial areas (The cell containing the distance is AN2). For example 10 and under is Area 1, 10.1 to 15 is Area 2, 15.1 to 20 is Area 3, 20.1 to 25 is Area 4 and anything greater than 25 is Area 5. Any help would be greatly...

Hello, As I described in the title, I'd like help with a formula that will allow me to count how many times the cell below a specified value is a number greater than zero in another sheet within a specified range. So let's say that I choose "J" as my specified value. I'd like the formula to...

I'm pretty sure this will require an array formula, but here goes. I have a table of 3 columns and 50 Rows in each column, all cells have numeric values, I need to add up all the values in the table if the value in each cell is greater than a given value, example is greater than "50".

Hi, I have a spreadsheet where I need to locate the bottom-most cell that's value is NOT 0 - however there is a possibility that the value we are looking for is numerically below 0. I found; LOOKUP(9.999999999999E+307,IF(Q1:Q300>0,Q1:Q300)) Which locates the bottom most cell with a value that...

I have a table that has 2-columns with dates in them and a 3rd column with peoples names. I want to use access to get rid of all records except associated with certain people (which I've figured out) AND that has a date in either of the 2-date columns that's greater than 12/2/2017. There are...

Two date columns. A & B. I want the column B to fill red if the date in column A is greater than 4 days. I want the column to turn green if if the date is less than 4 days. Help please :)

Hello, I am needing a tricky (for me) summation of a row. Row 1 - I have a very long row of percentage values ranging from 0 to 100. (Column A blank) Row 2 - I have a very long row of values ranging from 0 to Infinity. (Column A Blank) Cell B4 - I have a fixed value of 0 to Infinity. I need...

I need a conditional format formula to turn cell A1 colour to blue if cell A1 is < cell B1 and greater than C1, or Cell A1 to colour red if cell A1 is greater then cell B1 or leave cell A1 with no clour if A1 is less than C1. A1 = 0.5 B1 = 1.0 C1 = 0.75 I am stumped. Any help would be appreciated

Hello Everyone. I am having a very difficult time with an If Statement. It has been a very long time since I have done this so I am a bit rusty. The calculation consists of the following, Cell H12 has the calculation/function, Cell C12 needs to be greater than Zero, and cell M5 needs to also be...

I have a bunch of fields on a form where I entered conditional formula "Check values in the current record or use and expression Format on cells where the: Field Value is greater than 0 Then the formatting is set to make the fore color red if the value, which is calculated, results...

Trying to get an average of one set of data if the other set of data is greater than or equal to another number (cell referenced). I am getting a #DIV/0 error. Right now I have it written as averageif(A3:A27,">=A55",B3:B27). This returns a #DIV/0 error. I have made sure there are not spaces and...

I have data for 6 months of information. I want to create a formula to combat my question. Return a value of "yes" if 5 of the 6 months are greater then a value. Can this be done?