Results 1 to 8 of 8

Capacity Column Formula Is Not Calculating

Threaded View

  1. #6
    Registered User
    Join Date
    04-12-2010
    Location
    USA
    MS-Off Ver
    Excel 2013
    Posts
    11

    Question Re: Capacity Column Formula Is Not Calculating

    I have attached a larger section of my spreadsheet.

    As you can see in the sections above the "Non Working Section" at the bottom
    of the Metro Spreadsheet tab, the figures in the "Capacity" column are supposed to calculate the amount the tank can hold based
    on on the last inventory reading entered in the Inventory tab. For example, in the 2nd "This Section Works" section at the top
    of the Metro Spreadsheet tab, 6091 was entered at 5 pm. The figure is subtracted from the tank size of 17800. 17800 - 6091 =
    11709. The figure you see in the "Capacity" column.

    Now look at the "Non Working Section" at the bottom of the Metro Spreadsheet tab. 2140 is the 5 pm figure found in the 0274/1970
    row. The 5 pm figure should be subtracted from the tank size. 10450 - 2140 = 8310 should be the capacity reading but the cell
    shows 10450, the tank size. Why are the cells in this section not calculating properly?
    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. Capacity Column Not Calculating After 2nd Daily Inventory Is Entered / Help
    By izgetsmail in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-20-2017, 11:38 PM
  2. [SOLVED] Calculating Current Capacity on Fuel Tanks
    By GeminiG in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-13-2016, 01:15 PM
  3. table calculating complex capacity with variables
    By eli_88 in forum Excel General
    Replies: 5
    Last Post: 09-18-2015, 12:43 PM
  4. Formula calculating difference with one column
    By bidiminished in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-13-2013, 08:14 AM
  5. Lot sizes and capacity Formula
    By swiftrain in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-04-2012, 04:28 PM
  6. [SOLVED] Product capacity formula
    By swiftrain in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-30-2012, 01:42 PM
  7. Replies: 3
    Last Post: 06-16-2010, 02:38 AM

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