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.

7 Replies

  • Girish0311's avatar
    Girish0311
    Copper Contributor
    I am using the autosum and when I add a bunch of numbers the result is always zero why
  • Or you mean something like this

    Column A. Column B
    Cell A2: 5% Cell B2: 50

    In cell C2 =A2*B5 which is equal to 2.5

    ???
  • Hello,

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

    Cheers
      • Riny_van_Eekelen's avatar
        Riny_van_Eekelen
        Platinum Contributor

        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.

Resources