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
- Girish0311Copper ContributorI 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- BABA1978Copper Contributor
I have attached the file, Figures in coloumn G should not go negative if i change the figures in coloumn F.
- Riny_van_EekelenPlatinum 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.