Or maybe better (might depend on your wishes): =round(a1*1.35,2).
=a1+35 adds 35 to the contents of a1,indeed.
Kees
I have been trying to get exell to add 35% to a list of prices, all I can get it to do is add 35 to each one. Please Help me
![]() | Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years. Thanks, CNET Support |
I have been trying to get exell to add 35% to a list of prices, all I can get it to do is add 35 to each one. Please Help me
Discussion is locked
Or maybe better (might depend on your wishes): =round(a1*1.35,2).
=a1+35 adds 35 to the contents of a1,indeed.
Kees
I just typed in the "ask a question" in the help box in the upper right hand corner of Excell and got this:
I think this is what you are looking for.
Increase or decrease a number by a percentage
Use the formulas below to do these tasks.
Worksheet example
The example may be easier to understand if you copy it to a blank worksheet.
How?
Create a blank workbook or worksheet.
Select the example in the Help topic. Do not select the row or column headers.
Selecting an example from Help
Press CTRL+C.
In the worksheet, select cell A1, and press CTRL+V.
To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Tools menu, point to Formula Auditing, and then click Formula Auditing Mode.
1
2
A B
Number Percent Increase
23 3%
Formula Description (Result)
=A2*(1+5%) Increases number in A2 by 5% (24.15)
=A2*(1+B2) Increase number in A2 by the percent value in B2: 3% (23.69)
=A2*(1-B2) Decrease number in A2 by the percent value in B2: 3% (22.31)
Note When you use a number followed by a percent sign (%), the number is interpreted as a hundredth of its value. For example, 5% is interpreted as .05.
I have been trying to use that, I dont know what i am doing wrong but i still cannot get it to work. Thank you very much for your responce any other help would be apprated. Dyllanjazz
Dylanjazz,
Be cdlear. Share your formulas that don't work. Help us to help you.
Kees
As Kees said, this is elementary maths.
Example;
If you have $69 in cell A1, and what to add 35% to it in cell B1 -
100% = $69
1% = $69/100, therefore 35 of these becomes;
35% = ($69/100)x35
Therefore cell B1 should hold, (without the quotes), "=((A1/100)*35)+A1".
Explanation: B1 evaluates the formula in the brackets, inside brackets first, eg (A1/100), then multiplies by 35, then the result, (stored within the outside brackets), is added to A1. Thus 35% of $69 is added to $69 to give your result.
Try that.
Mark
PS I tend to work these out like this rather than using % functions, so that I know and understand the process step by step.