greater

=IF(AL2="",AND(OR(AD2="Coffee",AD2="Tea",AD2="Soap",AD2="Milk"),YEAR(AE2)>TODAY())) Hi, Can someone help me correct the above formula? AL: Column has words and blanks from inventory (Blanks remaining inventory, filled are sold) AD= Is the product we have AE= Date So if the AL column is...

Hi, I think this is simple. I have 6 months of data which is the variance from one month to the other. I need a formula that looks at all 6 cells and tells me if the % change is greater or less than 10%. I was thinking of using an IF(AND(MATCH then adding the >110% and <90% but wasn't sure if...

I am looking for code that would look at a column, and if the cell is greater than "0" it would recheck the check box when the form is opened.any help would be appreciated.

Hope you can help; I need to work out formula for if cell A1 is greater than cell B1 then return value in cell A1 and if cell B1 is greater than A1 then return value of cell B1. Any help would be greatly appreciated.

Hello If I have the following sets of data Cell K2 = 750000 Cell N9 = YES Cell B32 = 15 What formula can I use to say the following If Cell K2 >500000 and Cell N9 = YES and B32 is less than or equal to 20 then use the the value in cell B32, if it is greater than 20 then use 20 I hope...

Hi, I'm looking for a VBA routine to replace all values in COL A that are greater than 15 and less than 999, with the number 16. Thanks.

I have a list of Dates, Range A3:A298. I need to create a formula to Count thenumber of days in that range that are greater than 2 days old. I have tried using the =Today() in conjunction with CountIfbut so far everything returns Zero and I can see visually that there are 15 ofthem. What am I...

I have two columns with dates. Is it possible to check (with a single formula) that for each row, the date entered in column 2 is always greater than the date entered in column 1? many thanks

Hello, I am really having trouble figuring out how to do this and would greatly appreciate any help. I have a column of data and I need to analyze ranges of numbers like this example: 10.2 5.1 2.6 11.6 5.7 I want to make be able to calculate for example (and eventually convert to charts)...

I've done multiple search combination to find the answer, but unfortunately nothing matches what I looking for. I'm auto-filtering my data and I would like to count the number cells that is greater than 0 in VBA. Can someone assist. Thank you kindly

Hello, Excel noob when it comes to Index Match and first time posting. TIA! I am creating a spreadsheet to model portfolio trades based off of target trade amounts. I'm trying to prioritize the allocation of certain "Stock Types". I'm wondering how I could retrieve a specific figure based...

Help please! I have a range of different percentages in column V4-V78, I want to create a formula that will count how many times the percentage of 80%-99% appears in this column. I will then need to repeat the process for 60%-79%, so on and so forth. Eventually the column will be far greater...

Hi All, I'm trying to find a solution to my predicament and having attempted a number of ways (fuelled by similar older posts on here), I'm still not getting completely the right result. In short if I had six columns of random numbers: 10 | 0 | 0 | 10 | 0 | 5 How do I get Excel to return...

I put this formula in cell N406 =IF(D407:D420>0,"*",0) My range of D407:D420 is greater than zero...so why isn't an * showing up in the cell N406? My sum in the range is 13..so I should expect to see an asterisk, correct? Should it be something other than an "IF" formula?

Can someone explain how to write a IF formula in excel? If cell 10% of B9 is greater than 35, display the value, otherwise display 35.

Hi, How could I go about taking my cell value in S33 and selecting the closest greater than value in T19:T30, then returning the corresponding Overload in the column to the left of the closest greater than value? Which formulas would I use to achieve this? Thanks in advance.

<tbody> 101 101 101 to 102 12 = 102 11 103 10 </tbody> Hey guys i am trying to write a formula that will will check to see if column D is greater then 12 then it will check to see if column A matches column B then pull the information from column C into...

I'm trying to display a percentage based on a State Date and End Date. For example: Cell G7 - 6/1/19 (Start Date) Cell H7 - 8/30/19 (End Date) With formula in I7: =IF(H7>TODAY(),(TODAY()/(H7-G7),1) This gives me two conditions I want if the current date exceeds the end date; however, my...

Hi, Can someone please help me with this? I have this: Column A: Mike, Tim, Daniel, James Column B: 1, -1, -1,0 Column C: 22, 44, 66, 88 What is the formula that allows me to add in one cell, all values from column C that have a value greater than 1 in column B? I don't want to create a new...

i have a column with numbers 0-10. i want to display in a desginated cell. the current streak. as in currently how many cells in a row are greater than 0. from the top. how do i do this?