Shorter formula for percent calculation

Dear Experts,
I'm sure this can be done shorter and better?!

=(I25/(K25*100+I25)*(K25*100))

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

thanks

Petersburg1Asked:
Who is Participating?
 
Rory ArchibaldCommented:
Slightly shorter and does the same thing:
=I25*H25/(H25+I25%)
0
 
TinTombStoneCommented:
What percentage are you tring to get?
K25 of I25
K25 + I25

0
 
barry houdiniCommented:
Can you explain what the formula should do - in words?

regards, barry
0
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

 
Petersburg1Author Commented:
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 :-)
thanks

0
 
barry houdiniCommented:
Looks like Rory's suggestion will simplify, but I think he meant K25 not H25, hence should be

=I25*K25/(K25+I25%)

Points to Rory

regards, barry
0
 
Petersburg1Author Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.