Forum Discussion

BABA1978's avatar
BABA1978
Copper Contributor
Jun 27, 2020

How to use logical condiiton

How to use logical formula. one column contains % of withdrawal amt and one column contains Expenses .if i want to change expenses column the percentage column should accordingly.
Formulas and Functions
Abiola1's avatar
Abiola1
MVP
Jun 27, 2020
Hello,

The question is not clear. Kindly reword the question and/or upload a sample file

Cheers
  • BABA1978's avatar
    BABA1978
    Copper Contributor
    Jun 27, 2020

    Abiola1 

     

    I have attached the file, Figures in coloumn G should not go negative if i change the figures in coloumn F. 

    • Riny_van_Eekelen's avatar
      Riny_van_Eekelen
      Platinum Contributor
      Jun 28, 2020

      BABA1978 The expense in column F seem to be predetermined (fixed amount plus periodic inflation adjustments). If you then want to avoid the amounts in column G to go negative, the SWP Monthly amount in columns C may not be lower than the amount in F. In generic term, the formula in C would be like: "=MAX(Fn,<SWP Monthly formula>)", where n is the row number.

       

      To be more specific, on row 24 (= Month 21), the formula in C24 would be:

      =MAX(F24,(B24*3.5/100)/12)

       This will return 90825 in C24, resulting in 0 in G24 rather than -181.

      • BABA1978's avatar
        BABA1978
        Copper Contributor
        Jun 28, 2020

        Riny_van_Eekelen 

        Thanks for the reply. requires more help.

         

        The percentage in C24 remains static. If we increase or decrease expense the percentage (in C24)should change accordingly and balance column should not go negative

Resources