ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   formula forPercenteage (https://www.excelbanter.com/excel-discussion-misc-queries/86361-formula-forpercenteage.html)

OSSIE

formula forPercenteage
 

Hi there
I need help with a formula that would gime a percentage for example in
b10 int woul have the total amount like 103 on c10 it woul have the -25
and on c10 it would have the percentage of this 2 can you guys help
Thanks


--
OSSIE
------------------------------------------------------------------------
OSSIE's Profile: http://www.excelforum.com/member.php...o&userid=31638
View this thread: http://www.excelforum.com/showthread...hreadid=538122


Toppers

formula forPercenteage
 
If you mean 25 as a percemtage of 103, then format cell as percentage and put
in the formula:

=c10/b10

HTH

"OSSIE" wrote:


Hi there
I need help with a formula that would gime a percentage for example in
b10 int woul have the total amount like 103 on c10 it woul have the -25
and on c10 it would have the percentage of this 2 can you guys help
Thanks


--
OSSIE
------------------------------------------------------------------------
OSSIE's Profile: http://www.excelforum.com/member.php...o&userid=31638
View this thread: http://www.excelforum.com/showthread...hreadid=538122




All times are GMT +1. The time now is 05:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com