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
