Results 1 to 7 of 7

How to fix calculation when handling costs?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-25-2020
    Location
    United States
    MS-Off Ver
    Office 365
    Posts
    505

    How to fix calculation when handling costs?

    Hi guys,

    I was calculating costs and I notice the amounts in column D are correct but its calculated in correctly in cell N2 when referenced? I broke the calculation down in columns L through O. My other question is, I have the column D amounts formatted as Accounting, why does it show the .00 and if I remove it it is then formatted as Custom but the above two amounts are fine?

    Thank you in advance if you can assist.
    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. [SOLVED] Calculate Total Costs based on Recurring Costs, Start Date, and Frequency
    By edaniel202 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-05-2021, 12:18 PM
  2. [SOLVED] Date of hire calculation for labor costs
    By equplay in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-18-2015, 10:40 AM
  3. Error handling inside error handling
    By grantastley in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-06-2015, 03:43 AM
  4. Replies: 3
    Last Post: 07-28-2014, 08:57 PM
  5. sum the costs
    By tofimoon4 in forum Excel - New Users/Basics
    Replies: 9
    Last Post: 07-17-2010, 09:11 AM
  6. compare current mortagage costs to new mortagage costs
    By NEW2TECHBZ in forum Excel General
    Replies: 1
    Last Post: 04-05-2006, 03:47 AM
  7. Error handling with a handling routine
    By ben in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-15-2005, 11:06 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