Percentages in Excel

Microsoft Microsoft excel 2007 open lice...
July 15, 2010 at 16:18:33
Specs: Windows XP
I am trying to get my spreadsheet to automatically figure out what 4% of the dollar amount in cell A is and post it in cell B. How do i do that?

See More: Percentages in Excel

July 15, 2010 at 17:05:06
A is not a cell, nor is B.

They are both columns.

If you meant A1 and B1, then try this:

In B1 enter =A1*.04

Report •

July 16, 2010 at 05:33:30

If you want to show what is going on and be able to more easily change the percentage, do this:
Original value in cell A1
In cell B1 type 4% (no equal sign, just the number 4 and the % sign) and hit enter
Cell B1 will display 4%
In cell C1 enter =A1*B1
C1 will display the percentage

Now you can enter a new percentage value in B1 without using the percent sign
and without editing a formula.


Report •
Related Solutions

Ask Question