In Microsoft Excel,How can we get result when we add 30% with total amount? Please explain by formula?

Question

How can we get result when we add 30% with 1000

Answer 1

Lets consider that Total is in Column B, so the formula would be B2+(B2*0.3). I assumed the calculation for the 2nd row. Once you do this formula, just copy this formula for the rest of the rows.

Answer 2

Use a formula to calculate.

Here's what you want to do: 1000 + 30% of 1000

Put 1000 in cell A1

In cell A2 put this formula:

=A1 *130%

or if it is easier for you to understand do this:

=A1 + (A1*30%)

The parentheses are not necessary for the formula to work, but make it easier to understand.

Answer 3

If I understand you correctly it's as simple as this, let's say Cell A1 contains your amount "1000" and B1 is the cell you want to contain the result then in B1 type ==> =A1*1.3 <== (without the arrows of course)