[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
Solved

# Excel - Calculate Pecentage

Posted on 2011-02-11
Medium Priority
282 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
Question by:Hank11
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• Learn & ask questions
• 2
2 Comments

LVL 50

Accepted Solution

Dave Brett earned 2000 total points
ID: 34876247
balance = (1-X%) * 178
=40% *178
=71.2

Cheers

Dave
0

LVL 50

Expert Comment

ID: 34876264
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

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
###### Suggested Courses
Course of the Month14 days, 15 hours left to enroll

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

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