Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Shorter formula for percent calculation

Posted on 2011-10-10
Medium Priority
Last Modified: 2012-05-12
Dear Experts,
I'm sure this can be done shorter and better?!


I25 = Amount 100 (can change)
K25 = 18% (can change)
J= place of this formula and as result 15.25


Question by:Petersburg1

Expert Comment

ID: 36941858
What percentage are you tring to get?
K25 of I25
K25 + I25

LVL 50

Expert Comment

by:barry houdini
ID: 36941859
Can you explain what the formula should do - in words?

regards, barry
LVL 85

Accepted Solution

Rory Archibald earned 500 total points
ID: 36941891
Slightly shorter and does the same thing:
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.


Author Comment

ID: 36941922
In the I column I can have all kind of amounts, each row can be different.
In the J column I want to have the result (formula)
In the K column the user can choose the percentage which can be either 18% or 15% shown as percent.
Depending on the amount in I and the percent chosen in K I want the proper result in j as amount.
Taking 100 and 18 the amount I would expect is 15.25. the formula I have listed above and all works fine. However this looks a bit long to me and I wonder if there is a more "professional" way to get the same result. Maybe all is perfect, so I only would need your Expert confirmation :-)

LVL 50

Expert Comment

by:barry houdini
ID: 36941958
Looks like Rory's suggestion will simplify, but I think he meant K25 not H25, hence should be


Points to Rory

regards, barry

Author Closing Comment

ID: 36946847

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

581 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