If D4 through D9 are all percentages of D1, then it IS possible. D1 =
D11/(1-(SUM(D4:D9)). But if one of the deductions is U.S. federal
income tax, then that number should be a lookup, not a percentage, and
the backward formula won't work.
CD wrote:
Thanks. Thats actually the answer I expected, that it couldn't be done, but
ya' never know.
CD
|