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

Watch MrExcel Video

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