Archive of Mr Excel Message Board


Back to Dates in Excel archive index
Back to archive home

Need percentage formula

Posted by noir on October 30, 2001 11:18 AM
I am creating a Home Finances spreadsheet. At the top of my spreadsheet i list paycheck amount (example:$2,000.000). Withing my borders i list each bill and the dolloar amount owed (example:Cable TV, $50.00). As i fill-in each bill amount, i would like to show what percentage that bill amount is in relation to my pay amount (example:Cable TV, $50.00 = XXX% of $2,000.00)

What is formula please?

Thanks.
-noir


Re: Need percentage formula

Posted by Aladin Akyurek on October 30, 2001 11:40 AM
If $2000.00 is in say C1 and $50.00 for Cable TV in C2, then
you can use say in D2:

=C2/$C$1

and format D2 in Percent Style via Format Toolbar.

Is this what you're looking for?

Aladin

=====



Re: Need percentage formula

Posted by noir on October 30, 2001 12:36 PM
Yes, thanks Aladin!!!


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.