# conditional statement

1. ### 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...
2. ### 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...
3. ### 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>
4. ### 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...
5. ### 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...
6. ### 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...
7. ### 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...
8. ### 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...

### This Week's Hot Topics

• Problem in vba vlookup
Dear All Master, The problem I mean is as follows : 1. I want to modify the vba code because it takes too long/very slow to vlookup in VBA code...
• VBA Vlookup
Please for help. Why it`s not works? [CODE=vba]Sub Check_equpment1_click() Worksheets("Production_program").Activate Dim ans1 As Integer ans1 =...
• Nesting INDEX MATCH into SUMIFS
I currently have several formulas pulling in a SUMIFS from a data sheet, beginning with =SUMIFS('datasheet'!\$N:\$N, 'datasheet..... but as I am...
• Extracting number from a range randomly
Hello Expert, please kindly advise what is the best method to extract numbers from a range randomly I have a series of numbers in the range of A1...
• Problem with If Formula
I am using the following formula in cell A5. I would like if N5 is blank then A5 also return blank. If N5 is 0 or is greater than zero then equals...
• Is there a way to make the day's name show up automatically in a header?
I have a form I print out every day..and in the top right custom header I have the &[DATE], which automatically gives the current date in top...