+ Reply to Thread
Results 1 to 2 of 2

Multiplying by cells vs. raw numbers

  1. #1
    Registered User
    Join Date
    01-15-2014
    Location
    Tucson, AZ
    MS-Off Ver
    Excel 2003
    Posts
    3

    Multiplying by cells vs. raw numbers

    I am trying to calculate a salary increase for an employee. The hourly salary is $26.15. If I multiple that by 2080 hours (full time employee) I get $54,392.00.

    Then I checked it by calculating by gross salary times the rate of increase. In that case, I get $54,397.50. Does anyone have any ideas why they came out different?

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,913

    Re: Multiplying by cells vs. raw numbers

    My guess is that something (probably the hourly rate?) is not exactly what you show. Assuming that the hourly rate is subject to a rounding error, I can divide 54397.5/2080 and get 26.15264... (which would display as 26.15 rounded to 2 decimal places) -- suggesting to me that the hourly rate is not exactly 26.15, but something slightly larger than 26.15.

    Is that a possibility or is the hourly rate exactly 26.150000000000?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Multiplying numbers
    By mikkelno in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 05-10-2017, 09:43 AM
  2. Help with the result when I multiplying two numbers???
    By esopi in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 07-27-2016, 05:57 AM
  3. Multiplying numbers and letters
    By Stranqer in forum Excel General
    Replies: 5
    Last Post: 05-21-2016, 11:19 AM
  4. [SOLVED] multiplying two numbers
    By shimaa01234 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 02-21-2015, 06:01 AM
  5. Multiplying 2 cells with text and numbers
    By raphib23 in forum Excel General
    Replies: 2
    Last Post: 07-20-2012, 12:12 PM
  6. Multiplying multiple numbers in cells for 1 total.
    By jaloko in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-13-2010, 09:16 PM
  7. Multiplying Rounded Numbers
    By Fermentum in forum Excel General
    Replies: 4
    Last Post: 09-30-2008, 04:40 PM

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