Results 1 to 3 of 3

#DIV/0! Error - Most of the formulas work, except for a small few?!

Threaded View

  1. #1
    Registered User
    Join Date
    11-11-2015
    Location
    manchester
    MS-Off Ver
    Excel 2010
    Posts
    13

    Lightbulb #DIV/0! Error - Most of the formulas work, except for a small few?!

    Hi, reference the attached workbook...

    The workbook itself is quite complex but the formula isn't so complicated so I'm not sure why a small number of sites are showing #DIV/0! errors as a result.

    If you open the sheet and look at "RC.Total" tab and "RC.Mechanical" tab, Eastleigh, Reading and Jersey show this error. All other sites are as they should be.

    I can't figure out what's going wrong with the formula/figures.. Can anybody sus it out? My eyes are going fuzzy looking at it....

    Thanks!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Complex formulas for my small business
    By jasonscott in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-16-2015, 08:52 PM
  2. Index and Small Formulas returning #N/A
    By Arnie P in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-04-2014, 11:20 AM
  3. formulas don't work...macros error?
    By crisvesh in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-15-2012, 08:16 AM
  4. Transpose wont work with Small(IF) formula
    By FrederikBjerre in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-28-2012, 09:02 AM
  5. Excel 2007 : Work Book in Small window
    By andybocchi in forum Excel General
    Replies: 1
    Last Post: 10-31-2010, 04:09 PM
  6. [SOLVED] What is fastest for this? Small VBA or many worksheet formulas...?
    By Maria J-son in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-10-2005, 09:05 AM
  7. [SOLVED] Need help publish small work sheet to Web
    By AF in forum Excel General
    Replies: 3
    Last Post: 06-16-2005, 04:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1