if then else

Hello, I have a problem with declaring a variable which I want to use later in my macro. The problem is that I need to first "calculate" this variable which is dependent on the file name. I used "if then else" statement to pull out from the file name one thing that changes - week number. The...

I need to modify a complex array formula. Here's the logic.... 1st condition: if the value in column A matches with the value of column A in previous row; Condition passes.... Then check if the value in Column E has occurred for the 1st time for similar value of column A Condition...

I need to modify a complex formula using IF-THEN-ELSE that fits my requirement. In column I am using the formula "=((H2/20))" for calculating individual effort. Now, in column J, I need to display the remaining effort. For this I'm using the formula...

Hi all, Have an excel sheet I use to create estimates (each new estimate goes in row 2). Each time I create a new estimate, a row is inserted into column 2 pushing all previous records down. I have about 800 rows now. For each estimate/row, the company name is in Column A. Ultimately, I need...

Hello, I am new to this forum and I am new to Excel VBA. I apologize if this is redundant with another thread or post, but I have looked high and low via google and on this forum and have yet to found what I am looking for. I started with a simple if, then, else function as follows...

I can't get this formula to work. I suspect I'm missing something relatively simple. IF(H6=".Last Three Months.",SUMPRODUCT(--('Data Entry'!F4:F503=>'formulas'!H1),--('Data Entry'!F4:F503=<'formulas'!H2),--('Data Entry'!K4:K503,"Yes"),SUMPRODUCT(--('Data Entry'!H4:H503=H6),--('Data...

I'm doing a 'if then else' structure on vba - where i want the if then else function to work on every square - but i can't work out how to make it loop. so at the moment I want to know if each cell says depreciation and my code is: ActiveSheet.Cells(2, 1).Select If ActiveCell = "depreciation"...