Results 1 to 4 of 4

Excel not calculating correctly

Threaded View

  1. #1
    Registered User
    Join Date
    11-03-2011
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    2

    Smile Excel not calculating correctly

    I'm working on a worksheet to determine the amount an employee is to be paid. In one cell I have the amount (N9=29.82) the other the amount of hours (O9=64). In P9 I have the total which is (O9*N9). The problem is that excel returns a total of 1908.76. The actual total is 1908.48.

    This is a problem because the math error recurs in all cells with multiplication and I'm trying to link several worksheets for invoicing and will overpay by @ $30 each pay period if I dont go in and manually input the numbers. What can be causing this?

    Note. the cells are formated to two digets decimls only.

    The Rounding fixed everything, thanks!
    Last edited by atakpajr; 11-08-2011 at 03:33 PM.

Thread Information

Users Browsing this Thread

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

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