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?

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

Hi, 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 percentageNow you can enter a new percentage value in B1 without using the percent sign

and without editing a formula.Regards

Ask Your Question

Weekly Poll

Do you think manufacturers should do more to reduce phone and tablet usage among kids?

Discuss in The Lounge

Poll History