error messages

  1. A

    Error message if any of 3 cells are blank

    On a spreadsheet I have a "Save" button which saves the sheet in a specific place determined by the contents of 3 cells. C4 = Date, E4 = Venue, I4 = Name These three cells determine the location and name the file will be saved; c:\Venue\Year (from C4)\Month (from C4)\Name (a combination of day...
  2. D

    Pivot Table Blank Cells

    I have a pivot table that compares year-on-year sales data for accounts. If an account didn't have sales for the earlier year, the custom calculation errors #DIV/0! which I can show as <blank> at the account level. Problem is at the subtotal levels, I also get the error when I should be...

Some videos you may like

This Week's Hot Topics