Forum Discussion

LT_Pgh's avatar
LT_Pgh
Copper Contributor
Mar 23, 2020
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. 

excel
Formulas and Functions
  • Savia's avatar
    Savia
    Mar 24, 2020

    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.

7 Replies

Sort By
  • Savia's avatar
    Savia
    Iron Contributor
    Mar 23, 2020

    LT_Pgh Which part is missing a formula?  Can you talk through what the calculation should do?  I am not familiar with the basis points calculations.

    • LT_Pgh's avatar
      LT_Pgh
      Copper Contributor
      Mar 23, 2020

      Charla74 

      The fee needs to be calculated on the total value of $520,000, but the foundation (45,000) must receive the lowest share of the fee.

       

      • Savia's avatar
        Savia
        Iron Contributor
        Mar 23, 2020

        LT_Pgh You really aren't explaining this much.  From what I can tell, you need the value in E16 to be the lowest bracket reached by the prior calculation; I have done something for that in the attached.  If that isn't what you need, take some time to actually explain how the calculation works.

Resources