Excel Algebraic Formula Help

[ejseidman]

Hi!

I am looking for some assistance with an algebraic formula in Excel. In the attached spreadsheet, Column D is equal to ((Column A - (Column A + Column B) * 0.2)). However, in this case, Column B is known. If the number in Column B was blank, but I had A and D, how would I reverse engineer the formula to get Column B? It's been a while since my Algebra class ;-).

Thanks!

[Debraj Roy]

B2 =

Please Login or Register  to view this content.