chris waller

  1. C

    Date format not recognised in Countifs Formula.

    Dear All, I am trying to analyse some data in Excel that I have downloaded from Access. I get a File error message saying some number formats may have been lost. I suspect that it may be something to do with the date fields, because when I try to create a countifs formula in Excel, the formula...
  2. C

    Desk Calendar

    I have created a 15 month calendar in Excel. It runs from January 2015 to March 2016. The calendar is designed as such that it takes up half an A4 page in portrait. This is so another 15 month calendar starting January 2016 can be printed on the other half of the A4 page and this enables the...
  3. C

    Rounding Formula

    I have inherited an Excel Spreadsheet (Excel 2002) at work which contains the following formula (it contains 381 characters). The calculations are mostly to do with money. Some of the answers I get are correct. Some are a penny out and others are several pence out. I have managed to work out...
    • Chris Waller
    • Thread
    • chris waller excel 2002 excel 2002 formula rounding rounding formula
    • Replies: 5
    • Forum: Excel Questions

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
Back
Top