Trying to do a calculation in reverse using percentages and failing HELP PLEASE!
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.
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.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1