I'm having trouble trying to find an unknown value for a spreadsheet. Maybe there is some formula that can help me?
C1=B1/A1
C2=B2/A2
etc...
A5=SUM(A1:A4)
B5=SUM(B1:B4)
C5=SUM(C1:C4)
I want to have C6 show how much "B" column to subtract to get the value I want (15%) in C5. Maybe C5 says 64%, but I need to know if I want C5 to equal 15%, then I need to subtract "X".
Bookmarks