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

1. ## 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. ## 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.

#### Thread Information

##### Users Browsing this Thread

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

#### 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