greater

Hi Everyone, I'm new to this group and not well trained with Excel, I've spent my morning looking at formulas trying to find the solution. Here is the formula I have written, which works. I need to show a value of 7 if Z2 is less than 0.5, but I need it to roundup Z2 to the next whole number...

The formula below works as intended but I need some help please, to expand the formula so that if F31 is greater than 0 but less than 1195, it would return F31 and if F31 is greater than 1195, it would return 1195. =IF(F31>0,E27, 0) Thanks!

Hi All, I need a formula to work out payments based on performance, the challenge I'm facing is that there are various scales of payemnt depantdant on the formula. and I just cannot figure it out. So if A1 is greater than F1 but less than F2, I need it to show a bonus amount in H5. But then it...

is it possible to use this layout (they are tables, I couldn't get it to paste that way) and have excel look at all the tables and return the header and amount under the header of that table only if it is greater than zero? The tables are on one tab and the results/totals are on a different tab...

Hi All, I have a lot of data in excel. One of the columns is a finishing position of a runner. I am happy if this is a number 1 to 9, then this can stay at this number. However, the number could go up to 250. If a number is between 10 and 250 is there a Macro I could build/run that if any...

Hello, I have been looking for a formula and still get errors! If F2 <=110 = Short term OR IF F2 >111 OR F2<220 = Medium term OR IF F2>221= Long term I am looking for one formula with the 3 possibles results. Thank you in advance for your help! Zab

<tbody> Class Amount Yes (Formula Below) 1 -100 2 200 </tbody> Hello, I am having considerable trouble trying to get a combo of all three to function as intended. A very simplistic explanation. If 1 class is greater than 0 and 1 class is less than 0 then take the class with the...

Hello I have this very simple formula: =AA938/L938. I wish to add 200 to this (AA938/L938+200) only if another cell (H938) is greater or equal with 5200. (H938>=5200). Thank you very much!

Can somebody help me?: I already have the formula: =MAX(100,ROUNDUP(AB946/25,-1)) But, only if AB946 is greater or equal to 5200, I wish the result to be increased with 100 (+100). Thank U very much!

This is probably a simple fix, but I'm really new to Power Query and can't find an answer. I'm trying to compare square footage between two systems, but want to ignore any potential rounding differences less than -10 or greater than +10. My original formula was [#"Sqaure Foot A"] = [#"Square...

Hellow to everyone. Please help me. I have this Range("A2:D4") with fruits and quantity To load this Range in a Listbox Userform i use this code Private Sub UserForm_Initialize() ListBox1.RowSource = Sheets("Sheet1").Range("A2:D4").Address End Sub I want to know which is the vba code to...

Hi All, I'm having some issues with VBA. I want the code to look up cells within a range, that when greater than zero, copies and pastes adjacent columns as values in the same location (to remove the formulas). The lookup range is J10:J371, and if greater than zero, I want adjacent cells in...

I'm trying to create a spreadsheet that will keep track of my sales reps' advance/draw vs their revenues and commission amounts. For example: I have a sales rep who takes home either the greater of $3,000/mo, or 70% of revenues, provided his draw balance is at $-0-. So, he will always make at...

Hello everyone - I'm trying to input an If statement that says if date XXX PLUS 30 days is greater than date YYY, if true say "good", if false "Not good") For example cell A1 = 12/3/18 cell B1 = 12/15/18 So if cell B1 Plus 30 days (1/15/19) is greater than cell A1.....

Here is my code Sub RunEight() Call ThisWorkbook.formulaXXX Call result1 Call ThisWorkbook.formulaXXX Call result2 Call ThisWorkbook.formulaXXX Call result3 Call ThisWorkbook.formulaXXX Call result4 End Sub After result4 is finished, AF22 will have a value. Unless the number is less than 2...

Hello, After much research I haven't been able to find the formula I need. I am looking for a formula that will return a value based on what was entered into A2. I would like to insert a value into A2 then have the formula return a specific value base on a range. The range would be: If A2 is...

I am having a problem trying to count the values in a column when the value I want to count is greater than or equal to a value in another cell. For example in cell J5 I have the value of 70 and in column G13:G207 I want to count the times the values in column G13:G207 is greater than or equal...

Need a hand please. I'm not great with formulas in Excel.. Searched the forum with no luck with the help I need. Below describes what I need to create a check digit. Looking for a formula to do this in Excel. Thanks for looking and help. The calculation is as follows...

Hi, I am trying to set up a formula which will sum the numbers in one column that meet the following criteria in two other columns: a particular month (in one adjacent column) and greater than or equal to +0.5 (in a second adjacent column). I've put the following formula in but can't get it to...

Here's what I'm trying to accomplish. When macro runs, search column D:J on the GrossNet sheet, and if a value greater than 50 or less than -50, display a prompt "Value greater / less than 50 present, do you want to proceed?". If yes, continue macro, if no, end macro. I have some code below...