Forum Discussion
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
- 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
CheersBABA1978 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.
