conditional statement

I am using the following intercept function to successfully calculate Alpha from daily gain and loss % {=(INTERCEPT(AJ52:AJ2651,BD52:BD2651) +1) ^252-1}. I now need to use the formula to calculate Alpha but only if a condition from another column is met. In other words, if the data in...

Hi Folks, Excel novice. I have always had a problem with time calculations. I know that nested conditional statements are required to meet my desired goal. Your patience is appreciated. The conditions Values Required within 30 days of Start Date Values Required within 30 days of Midpoint...

I'd like to perform the product function for cells in the rows that contain the year 2016. I tried the following code but it just returns FALSE. My thinking: if the year of the date in column A contains "2016", then multiply the corresponding cells in column A for these rows. Any suggestions...

I need one cell to be subject to the followingconditional statements and just can't get the formula correct. Basically I need the cell to calculate three different conditions =if(l8<10,0,l8)<o:p></o:p> =if(l8>=10,and(c8>15),l8,0)<o:p></o:p> =if(l8>=20,and(c8<15),l8,0)<o:p></o:p>

I'm not sure what I need to do here, it may be a simple statement. But I need the sums in E3, F3, G3 to automatically update when the status in column H is answered with "deal lost". For example, A5 company is a lost deal, so I need E5 and F5 to be removed from the summed totals in E3 and F3...

I hope this can be done with a simple conditional statement: I have columns A B C of data. If the value of column B is False I would like column C to be populated with the corresponding values in column A. A B C 123 True (blank) 456 False 456 789 True (blank) abc False abc If I can't use a...

Hi, I am wondering if it is possible to run a VBA procedure based on the value of a cell, or an automatic cell value change (not user driven). Option 1: I have a cell that outputs one of two different messages based on a conditional statement. I only want the VBA code to run automatically...

I work in a hospital doing clinical genetic research on pediatric patients, primarily Neurofibromatosis type 1 patients. For several of the studies we are performing, we do a few different types of bone scans: DXA, pQCT, and QUS. We then extract the data from the machines, which is easily pasted...

I am trying to do calculations in a spreadsheet so that the cells are calculated in order; across a row, then down to the next row; across that row, down to the next and so on. In doing so I am using conditional statements to pick up text from a separate column of cells filled with text that I...