I am trying to increase a number in a column by a percentage but I want
to increase the entire column.
On 2022-03-29 08:48, Alan B wrote:
You want to...
a) increase certain entries by a percentage
- or -
b) increase a percentage already in the spread sheet
If a) then enter the percentage in a cell of your choice, remember
percentages less than 100% are entered as fractions, e.g. 20% is
entered as
.2, 45% as .45, and so on. Multiply the value that needs to increase by
the
percentage and add that amount to the value.
If the value is 55 and is in cell B1
and the percentage to increase is 10% and .1 is entered in C1
and the new value should appear in D1, then in D1 enter the following
=B1+(B1*C1)
If b) and there is a cell with a percentage already in the spreadsheet,
and
that percentage is being used already in formulas in the spreadsheet,
then
change the percentage to the new value.
On Mon, Mar 28, 2022 at 11:40 AM stmo <s...@cruzio.com> wrote:
I have spent an entire week trying to find an answer to this.
I need the formula and exactly where to put it in order to increase a
percentage amount in a spread sheet with numerous entry's Could not
find in FAQs We use windows 10 and OO 4.4.5
Thanks
Karl G
--
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011
