conditional statement

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

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top