What is the excel formula for figuring out a percentage?

Question

I have a currency figure in A1 and a commission amount in A2, how do i calculate what percentage A2 is of A1?

Answer 1

=A2/A1

also click on FORMAT PERCENT

Answer 2

In cell A1: type your currency

In cell A2: type the commission value

In cell A3: type "=A2/A1" (without quote) then hit Enter

In cell A3: right click then select Format Cells

In Format Cells window: select Number tab.

In Number tab: select Percentage option then click OK button

or visit my blog at excel-tutorial-video.blogspot.com

to see more illustration (with different metode in apply percentage)

Answer 3

That would be A2 divided by A1.