formulas in a cell

Hello Excel Gurus, I am trying to write a macro which will search through an entire worksheet for a specific formula (excel add-in) and replace it with another special formula (excel add-in). The added twist is that the syntax for each formula is different. Details as follows: Formula A...

I need to calculate a bonus paid to a salesperson based upon multiple factors. IB Pay = hours per demo (f4) then it looks at the pay period (a2) depending on the pay period (due to seasonal volume) would dictate which bonus structure to use see tables below. Once you determine what the...

I am trying to figure out 2 equations that I am stuck on. Question 1: I have a cell dedicated to the number of cars not cleaned (A91) and I want to pull data from a column of cells on the same spreadsheet that are labeled "# Cleans/month". The values of those cells (G79:G115) range from 0-4...

Hey everyone I'm using this code to make a table for a graph to update by selection of data but I'm using a very inefficient method to do it. it works but I am wondering if there is a better way. Range("B22").Select ActiveCell.FormulaR1C1 = _ "=(COUNTIFS('Hidden graph...

I know you can make static rows repeat at the bottom with custom footers. However, it is limited to what footer options allow you. I wanted to see if there was a way to make rows repeat at the bottom that had formulas written into it. It is preferable to do so with out macro help as well. I...

Hi, I'm trying to create an hours sheet, where I have employees select a dropdown with all the projects they are working on and then writing down the hours for it for each day of the month, e.g. the sheet will have days 1 to 31, the next column will be dropdown and the 3rd column would be where...

Hi, I'm new to posting on forums like this so bare with me as I try to explain what I'm attempting to accomplish. My company has a lab and we run different tests for different samples. I'm trying to find the total time the sample will take to run based on the tests selected. We currently have...

i need help with some formulas for this sheet i need to create basically what i want the sheet to do is to locate the names in column 1 who have value greater than x in column 2 and then reflect it into a new tablet now i'm very open minded like if there will have to be several sheets or if...

I have the current formula to use as a count based on 2 criteria. =SUMPRODUCT((TEXT(Order!A2:A65535,"m/dd/yy")=TEXT('Order Confirmation'!$L$13,"m/dd/yy"))*(Order!H2:H65535>=1)*(Order!A2:A65535<>"")*(Order!H2:H65535<>"")) Column A on my Order sheet is an entered date and L13 is a specific date...

Hi all, I have a formula: =IF(C7<0.000001,"Remote/Improbable",IF(C7<0.00001,"Unlikely",IF(C7<0.0001,"Possible",IF(C7<0.001,"Likely",IF(C7<0.01,"Frequent"))))) I use this formula with differents cells each time, ie, C7, C10, C12, etc.. 1. Can I write the formula in another cell and each time I...

Hi, New here and my experience level with excel is only a little above basic. using Excel 2010 and trying to mock up a time sheet template; have got most formulas in place however need a bit of help with simplifying the formula below...

Hello! As part of a macro, I have a formula in a cell that calculates the difference between 2 other cells. Now, I am trying to insert an IF statement into another cell that will look at this difference, and if the difference = 0, it will return the words "ON TARGET" in the cell. If the...