conditional statement

  1. V

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

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

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

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

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

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

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

    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...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

This Week's Hot Topics

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top