# 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

###### Who is Participating?

Commented:
Slightly shorter and does the same thing:
=I25*H25/(H25+I25%)
0

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

0

Commented:
Can you explain what the formula should do - in words?

regards, barry
0

Author 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

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

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