Forum Discussion
Solved
Complicated IF calculation
I would much appreciate any help for the attached calculation. I cannot figure out an accurate formula for the bottom portion as those results depend on the values at the top.
LT_Pgh I had a look at the calculator and thought about how I'd do it, and redesigned the calculation. The easiest way to do what you want is to calculate the fee for the whole estate, then the fee just for the family portion; the difference is the foundation fee. I also reworked the fee calculation into a single formula.
