Shorter formula for percent calculation

Posted on 2011-10-10
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
    LVL 6

    Expert Comment

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

    LVL 50

    Expert Comment

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

    regards, barry
    LVL 85

    Accepted Solution

    Slightly shorter and does the same thing:

    Author Comment

    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
    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


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Suggested Solutions

    I've recently been in need of an Excel macro that could add a letter before the text on multiple cells in an Excel document. My English is as it is, so I will try explain what it does diffrently. If you have an excel document with 2000 rows an…
    This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
    The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
    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.

    737 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

    21 Experts available now in Live!

    Get 1:1 Help Now