Solved

Excel - Calculate Pecentage

Posted on 2011-02-11
2
274 Views
Last Modified: 2012-05-11
I'm brain dead on a Friday afternoon and a little embarrassed with this.

I have a starting number xxx  i.e. 178 and need to reserve 60% of this and show the remaining balance 71.

Need a quick percentage formula.
0
Comment
Question by:Hank11
  • 2
2 Comments
 
LVL 50

Accepted Solution

by:
Dave Brett earned 500 total points
Comment Utility
balance = (1-X%) * 178
=40% *178
=71.2

Cheers

Dave
0
 
LVL 50

Expert Comment

by:Dave Brett
Comment Utility
the reserve is
X% of total
 ie 60% of 178
= 106.8

so onece you have either reserve or balance you can subtract from the total to calculate the other
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now