Percentage

Copper Contributor

Good Morning,

 

I am new to using excel and I need to the spreadsheet calculate a percentage of a certain amount so my staff doesn't have to do that  part of the required task.  How can I set it up?

2 Replies

@Annette385 If the value is in A1 and the basis of the percentage is in B1, it's just =A1/B1.  You then format as a percentage from the Home formatting menu.

@Annette385 

 

Hello, kindly see sample solution attached

 

Abiola1_0-1585588748608.png