You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openoffice.apache.org by stmo <st...@cruzio.com> on 2022/03/28 15:37:26 UTC
Spreadsheet
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
Re: Spreadsheet
Posted by Chuck Spalding <cs...@gmail.com>.
Karl,
If I correctly understand your objective, try these steps:
1. Enter the desired multiplier in any cell (e.g., 1.05 for a 5% increase).
2. Select that cell and copy to the clipboard (i.e., Edit > Copy).
3. Select all the cells you want to modify (e.g., click on the first cell
and Shift-Click on the last cell).
4. Select Edit > Paste Special...
5. Click on the "Multiply" selection under "Operations".
6. Make sure "Numbers" is selected in the "Selection" choices, or simply
select "Paste all".
7. Click on "OK".
If you don't like the result, you can select Edit > Undo: Copy to restore
the previous values. (Don't ask me why it's "Undo: *Copy*" when you just
did a *Paste*. ;-)
Note that the "Multiply" selection in the Paste Special dialog is retained,
so you will need to be careful if you next want to use Paste Special for a
different behavior.
Chuck
On Tue, Mar 29, 2022 at 9:27 AM stmo <st...@cruzio.com> wrote:
> I am trying to increase a number in a column by a percentage but I want
> to increase the entire column.
> [snip]
>
> > On Mon, Mar 28, 2022 at 11:40 AM stmo <st...@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
>
[snip]
Re: Spreadsheet
Posted by stmo <st...@cruzio.com>.
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 <st...@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
Re: Spreadsheet
Posted by Alan B <ab...@gmail.com>.
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 <st...@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