18th September 2018

office
11

How do I add 10% in Excel?

Here's how to do it:
  1. Enter the numbers you want to multiply by 15% into a column.
  2. In an empty cell, enter the percentage of 15% (or 0.15), and then copy that number by pressing Ctrl-C.
  3. Select the range of cells A1:A5 (by dragging down the column).

In this manner, how do I calculate VAT backwards?

VAT calculation formula for VAT exclusion is the following: to calculate VAT having the gross amount you should divide the gross amount by 1 + VAT percentage (i.e. if it is 15%, then you should divide by 1.15), then subtract the gross amount, multiply by -1 and round to the closest value (including eurocents).
Write Your Answer

Rate

60% people found this answer useful, click to cast your vote.

3 / 5 based on 2 votes.

Bookmark

Press Ctrl + D to add this site to your favorites!

Share