+ Reply to Thread
Results 1 to 2 of 2

Trying to do a calculation in reverse using percentages and failing HELP PLEASE!

  1. #1
    Registered User
    Join Date
    02-20-2013
    Location
    Doncaster, England
    MS-Off Ver
    Excel 2010
    Posts
    10

    Trying to do a calculation in reverse using percentages and failing HELP PLEASE!

    Hi All,

    Not sure if anyone can help me or not but here goes...

    Im trying to do a calculation in reverse using percentages

    I know that 5.0436/8.7=55%

    But i need my spreadsheet to do 5.0436+%=8.7

    I also need to drag it across the rest of the rows as they all need to be 58% of there original value which is unknown on that spreadsheet.

    The only formula i could think of for the attached is =((D4*B5*C4)*C5)/1000000 but this formula only adds on 58% of 5.0436 (2.925) making my tons 7.968.
    D4 is the cases i have
    B5 are the grams per unit
    C4 the amount of units in a case
    C5 the yield i want adding on (cell that i know is incorrect)
    /1000000 is to convert it into tons

    Hope this makes sense.

    Document 1.xlsx

  2. #2
    Registered User
    Join Date
    02-20-2013
    Location
    Doncaster, England
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: Trying to do a calculation in reverse using percentages and failing HELP PLEASE!

    Managed to solve it with a bit of trial and error. Turns out I just needed to times it by 1.7 and it works on all the other quantities too.

+ 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