# conditional statement

1. ### Conditional Intercept

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...
2. ### Conditional Formatting: Having trouble with time calculations

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...
3. ### If/Then (For Rows in Column A containing year, multiply corresponding cells in Column C)

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...
4. ### Multiple conditional statements in one cell?

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>
5. ### Removing Data based on a Condition

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...
6. ### new cell value based on value in another column same row

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...
7. ### VBA Trigger

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...
8. ### VBA, Conditional Statements with Multiple Criteria, or Pivot Table? Getting started?

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...
9. ### Calculating cells in order

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...

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back