greater

I'm looking to use a macro and not a formula to do delete old invoices automatically. please help if today is greater than 2/1/2019 then delete column A

Head scratcher for me I'm afraid A1 - B1 If the answr is greater than zero then show the result, else show a zero Any one got a clue about this?

I expect this is a more logical way to achieve what I want but I cannot conceive it The following does not work. IF B4 is less or greater than C4 by a value of 2 or more I want to return a false. =IF(OR(B4<(C4-2)),(B4>(C4+2)),false,true) Thanks in advance Lunar

Hey, The following is a Vba script that would be needing some altering so that if the value in cell B3 is greater than 21 AND it is not equal to Selection.Column then my code. If Worksheets("HSheet").Range("B3") <> Selection.Column Then The above is missing B3 is greater than 21 condition...

Hi, can someone help me with a formula that will find a value if the gap between numbers is greater than others in a range by “10” or more. Eg Column A 106 93 82 68 124. - highlight green 94 77 79 94

I need an Excel formula that will calculate the following: If J6 is greater than 100, then it will calculate the amount in L6 but if it is equal to or less than 100, then it will calculate the amount in K6 and J6 will show a zero and vice versa.

I have a column that is in text format with entries like 00:01:22, 00:00:38, 00:10:55, 00:00:09, etc. These are times as in hours:minutes:seconds. I need to put a filter on these and filter anything that is greater than 15 seconds, i.e. ' > 00:00:15 ' I tried the recorder, but couldn't make it...

Hello, I am hoping someone can help me with figuring out a formula to check if the last value in a row is greater than the first value in the same row then yes else no. There are only 4 cells in the row and they may have blanks. If the first cell is 2 and the next is 3 but the next is 2, then...

I need a formula that is able to sum data from one table, that has to match criteria that is in another table. If values from months January through December, columns A-L, in table 1 are greater than 0. Then I want to only select the months whose values are greater than 0 as my criteria, to...

I need to show certain percentages if certain numbers come up. The formula can be in A1 and the number can be in B1. Example: If B1 is equal to 2.9 or less put in a 0 if B1 is equal to 3 but less than 3.5 put 10% if B1 is equal to 3.5 but less than 4.0 put 15% if B1 is equal to 4 but less than...

This is a question I am struggling with to help one of my students.... In the Profit - Loss Summary worksheet, in the cell D8, use the If function to show Close if the SUM of C9:D9 is greater than22500 and Not Close if it is less than or equal to 22500.

<tbody> NAME A B C D 0% 1 561 91% 2 560 86% A 0% </tbody> If Column A is Greater than 0 and Column B is greater than 90, then find the MAX of column B, and display Name Cell. It should give you (1). Also the same as above but instead of MAX I need the MIN...

Good morning I have a strange request. I am working on calculating if an employee missed any time during the previous month. I have it written to a table and am using Conditional Formatting to highlight any value greater than 0 (That would indicate lost time). If in any month prior to the...

Hi, I am looking to create some sort of formula that can throw an alert for the user if the upward trend is increasing. I need help with the algorithm For example, Months Jan, Feb, Mar, Apr, May, Jun Values 1024, 1130, 1250, 1375, 1425, 1250 Displaying this in a chart you could say the cost...

I am trying to work out an IF statement (within one cell) that would reflect If A2 is less than 0, return 0. If A2 is greater than 100, return 100, if it is in between 0 and 100 then it's A3+A4. Any help is much appreciated. Thanks Chris

Hey all, Still learning how to use excel, however I have a budget sheet I made I've been using for the past few years. Simple stuff, just my income vs outcome vs savings. This year I've added a "Wish List" Sheet to it, and I was wondering if anyone could help me with a formula. So I have...

I am creating a template to fill out for work. Looking to have Row 14 appear ONLY if Cell D13 is greater than "1". Thanks in advance.

Hi Excel Wizards, I've been trying to figure out a solution for the following problem. In one column, I have a series of dates that stretch back between 1 day to several years. I'm trying to come up with a formula that would highlight the cell as being red if the time is > 14 days, yellow if...

Hi! New here and trying to learn some more complicated Excel tools. I have a spreadsheet where I want entire rows to drop down to the bottom when the value of a cell is greater than todays date. The cells of interest would be starting at G17 on. Any help would be amazing!

Hi, I am using conditional format to alert me when cell A1 is greater than 0. The cell is a result of a formula =if(B1>B2,"More","Less")<b2<b2,"more","less")<b2,"more","less") <b2,"more","less") I have the format change to red and bold, from default (black and non bold) =A1>0 I'm wondering if...