if statement quotation

  1. R

    Counting January dates with sumproduct from cells populated with if statement “” evaluates #value!

    Excel 2007. I have a workbook with three main sections that share information. 1. Project sheets. These have random sheet names and contain project information. In cell S16 I am calculating a start date based on project type and status. I am checking to see if cell 108 is filled in to...
  2. I

    Help with "IF" statement

    I have 3 columns as shown: Order Amount, Outstanding, Status <table style="border-collapse: collapse; width: 261px; height: 185px;" border="0" cellpadding="0" cellspacing="0"><col style="width: 92pt;" width="122"> <col style="width: 62pt;" width="83"> <col style="width: 62pt;" width="82">...
  3. S

    Insert IF statement into a column of cells

    Hi: I am trying to insert an IF statement into a column of cells, but I am not sure where to put the quotation marks... I am getting an "application defined or object defined" error when I run the code here is what I have Range(Cells(2, Agency), Cells(NUM_POS, Agency)).Formula =...

Some videos you may like

This Week's Hot Topics