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
Bookmarks