Excel question?

Question

Hey I'm sorry my english is kind of bad, I've got a question about excel

How can I add a certain procentage from let's say D6 to D7?
So something like =D6+19% (not working)

Thank you :)

Answer 1

=(D6/100)*119 gives the new total

or =(D6/100)*19 to give the percentage change

Answer 2

You would have to multiply by the percentage.

If D6 is the number 100, then 100 percent of D6=100. You want to add 19% to D6, so you're looking for the number 119.

In D7 you would type the following
=D6*1.19

The way it works is as follows:
D6*1=D6
D6*.19= 19% of D6 (19% is .19)
therefore, D6*1.19 is the same as saying D6+19% of D6.

Answer 3

You would need to calculate the percentage yourself. If you want 19%, you multiple the number by .19

So the formula in D7 would be = D6 + (D6 * .19)

You could also use =D6*1.19, which would give you 119% of D6. But the first formula is easier to understand what you are doing.

Answer 4

+19% of what? That's the problem. If 19% of D6, try =D6*19%+D5. Hope this is what you're talking about. If not, post back with what you're trying to get 19% of. Cheers!

Answer 5

=D6*(1+19%)

You need the 1+ for the formula to work

Answer 6

Try this in cell D7 (without the quotes):

"=D6*1.19"

Answer 7

=D6 * 1.19,

if you're trying to add 19% to D6.

Answer 8

Try =D6*1.19