+ Reply to Thread
Results 1 to 5 of 5

multiplying a cell by another which contains a formula

  1. #1
    Registered User
    Join Date
    03-27-2008
    Posts
    3

    multiplying a cell by another which contains a formula

    Hello,
    I have a problem in excel that's just driving me nuts.
    Can anyone explain this:

    ok...
    all of these are "number" format cells

    d29 = 24428.15
    d30 = 97.00
    d31 = d29/d30 (this comes out to be 251.84 on my spreadsheet)

    i then have d34 = 31.00
    and
    d35 = d31*d34 (this is where i'm getting incorrect number)

    d35 should be coming out to 7807.04
    but it's coming out to 7806.93 ????


    i can't figureee it outtt ??

    any advice will be greatly appreciated

    thanks
    aaron
    Last edited by asikora15; 03-27-2008 at 10:45 AM.

  2. #2
    Forum Expert darkyam's Avatar
    Join Date
    03-05-2008
    Location
    Houston, TX
    MS-Off Ver
    2013
    Posts
    2,191
    I don't understand your issue. D31 and D35 have the same formula, how are you getting different numbers for them? Also, why have the same formula in two different cells?

  3. #3
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,902
    I assume you meant the formula in D35 is =D31*D34, correct?

    Well you division formula D29/D30 does not give exactly 251.84... it gives something like 231.8365979 ... you probably have the cell formatted to show 2 decimals.

    That's why the multiplied result comes out the way it does...and not the way you think it should be.

    If you need the 7807.4 result, you need to change formula in D31 to =ROUND(D29/D30,2)
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  4. #4
    Registered User
    Join Date
    03-27-2008
    Posts
    3
    Quote Originally Posted by darkyam
    I don't understand your issue. D31 and D35 have the same formula, how are you getting different numbers for them? Also, why have the same formula in two different cells?

    sorry.. i typed that in wrong...
    (if you can tell.. it's got my head spinning)

    i corrected my original post.. sorry

    thanks

  5. #5
    Registered User
    Join Date
    03-27-2008
    Posts
    3

    Thank You

    Quote Originally Posted by NBVC
    I assume you meant the formula in D35 is =D31*D34, correct?

    Well you division formula D29/D30 does not give exactly 251.84... it gives something like 231.8365979 ... you probably have the cell formatted to show 2 decimals.

    That's why the multiplied result comes out the way it does...and not the way you think it should be.

    If you need the 7807.4 result, you need to change formula in D31 to =ROUND(D29/D30,2)
    THANK YOU SO MUCH ! !! ! ! and for responding so quickly ! ! !
    i swear... i was losing my minddd.. thanks thanks thanks

    - Aaron

+ Reply to Thread

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