Archive of Mr Excel Message Board
Back to Dates in Excel archive index
Back to archive home
Need percentage formulaPosted 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?
Re: Need percentage formulaPosted 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:
and format D2 in Percent Style via Format Toolbar.
Is this what you're looking for?
Re: Need percentage formulaPosted by noir on October 30, 2001 12:36 PM
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.