perform

I need to determine if a cell is greater than a number then perform one calculation and if its less than then perform a another calculation. Example: If A1 is less than or equal to 500 then subtract 200 and multiply it by 10% or .10 If A1 is greater than 500 then subtract 250 and multiply it...

I need to determine if a cell is greater than a number then perform one calculation and if its great then perform a another calculation. Example: If A1 is less than or equal to 500 then subtract 200 and multiply it by 10% or .10 If A1 is greater than 500 then subtract 250 and multiply it by...

Hi all, I am just looking to speed up a section of one of my macros as it seems to be lagging and I perform this macro in a high stress period of my job so it would be great to speed things up. I have to perform this macro to about 20 worksheets every 2 weeks or so. Usually only 2 of the 20...

Hi guys Is it possible to use VBA to achieve the following: Determine if cell "A1" on Worksheet1! = the name of a table on Worksheet2! If it does, perform an INDEX in Column 2 and MATCH in Column 3 of that table I basically want the code to perform something like this: IF A1 = A table...

Hello Marvelous EXCELers, Here is what I have: In cell A2 I have a value (numeric), in cell B2 a set of codes (alphabetic) delimited with a comma. Here is what I need: I need to find out how many entries will be parsed into individual columns if I perform a Text-To-Columns operation on cell...

Is it possible to to assign a button to complete 1 loop then a second click would perform the the next part of the loop?

Hi all, I am kind of a newbie to excel and would appreciate your help. I set up a budget sheet and I am trying to figure out a formula that will automatically perform a set function on the same day each month. As example: I want a cell to show the monthly adjusted balance of an auto loan. It...

Hello, I am trying to write a formula that will perform the following function, and drag down a column: IF the value in column K is <0, the value in the same row of column I is the equivalent positive. The values in column I remain as a maximum. This is an example of the result I'm looking...

Hey Folks: 2 questions: Multiple IF Statements Background: Calculating flowthrough, returning a score (0%, 25%, 50%, 75% or 100%) based on whether sales (F5) are positive or negative) End Goal If Cell F5 is > 100%, perform these statements...

Hi, I want to perform the same macro on different sheets in my workbook. I have 10 sheets for which I want to perform the macro. (Sheet "2007" to Sheet "2016) This is the code to be executed on every sheet : Sub SelectName() Sheets("2007").Select Range("A" &...

Occasionally, for some reason, much to my surprise,I am unable to SAVE my changes to my Excel workbook. Is there a way I can uncover the offending cell that is preventing the SAVE? I typically use this workbook as my "bookmark warehouse" to store URLs and my comments in cells and...

I know how to write an IF statement that looks at a string of text, and will perform an action if the string CONTAINS a certain "word" using =IF(ISNUMBER(SEARCH("*word*",A1)),"word","") But Is it possible to write an IF statement that looks at a string of text, and will perform an action if the...

Excel friends, Let's say wherever this vlookup(?,$B5:$C25,2,0) shows up in a Workbook. If I have defined a name for all ranges, and $B5:$C25 is Prices, then the VBA code should replace the vlookup to show: vlookup(?,Prices,2,0). I would like to find a VBA code to perform this kind of...

Hey, Whenever I try to assign a keyboard shortcut to my personal macro's they never work.. it sticks to it when I go back in to change the key however when I try to perform it it doesn't work. Is something blocking this from my settings as non-personal macros work fine? Thanks,

Hello, I would like to perform the following formula with 1802 being in cell B2, can anyone help please? Many thanks. =SUMIFS([1802.xlsx]REVENUE!$V:$V,[1802.xlsx]REVENUE!$K:$K,G6,[1802.xlsx]REVENUE!$E:$E,I4)

Colleagues, I have faced the following issue: I need to perform similar calculations on different inputs, saving the output. Is there any way to use Excel workbook as framework for those calculations? For example, I need to perform A + B calculation. I created workbook WB1, which contains on...

Hello all, I have noticed a very interesting behavior when I was measure the timing on my macro? I have used a pretty common method. Set the timer in the beginning of each iteration and then display how long each iteration takes. In the beginning it was taking around 8 seconds for each loop and...