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

General discussion

Formula help in excell xp

Nov 18, 2004 4:39AM PST

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

- Collapse -
Elementary math: =a1*1.35
Nov 18, 2004 5:11AM PST

Or maybe better (might depend on your wishes): =round(a1*1.35,2).

=a1+35 adds 35 to the contents of a1,indeed.

Kees

- Collapse -
Re: Formula help in excell xp
Nov 19, 2004 10:45AM PST
- Collapse -
Re: Formula help in excell xp
Nov 20, 2004 1:32AM PST

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.

- Collapse -
Re: Formula help in excell xp
Nov 22, 2004 1:14AM PST

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

- Collapse -
Trying to use what?
Nov 22, 2004 7:12AM PST

Dylanjazz,

Be cdlear. Share your formulas that don't work. Help us to help you.

Kees

- Collapse -
Re: Trying to use what?
Nov 23, 2004 6:59PM PST

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.

- Collapse -
Re: Formula help in excell xp
Nov 24, 2004 9:28AM PST

Simply multiply the figure by 1.35

eg field is AI

B! is where you want it

Formula is =A1*1.35

Tony