Solving simple equasion

Bright01
Bright01 used Ask the Experts™
on
EE Pros,

Can someone help me with solving the reverse equation for the formula in Cell F8?

Thank you in advance.

B.
Solve-Reverse-Eq.xlsx
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Managing Director/Excel VBA Developer
Distinguished Expert 2018
Commented:
Hi B,

If you are working in reversal order, universal rule to find Cost Price is Selling Price x 100 / 100 + Profit(%)
In Excel as you have H8 as 150%, above formula will be multiplied by 100 within Brackets as below
=G8*100/(100+H8*100)

Open in new window

Where G8 is Selling Price x 100 / 100 + H8 as Profit(%) x 100
Check in attached...
Solve-Reverse-Eq.xlsx

Author

Commented:
Shums,  Thanks for the quick answer!  Appreciate your help although I believe this was one of the less challenging questions you have resolved for me ;-)    Appreciate the work and accuracy.

B.
ShumsManaging Director/Excel VBA Developer
Distinguished Expert 2018

Commented:
You're Always Welcome! Glad I was able to solve this one as well :)
ste5anSenior Developer

Commented:
Your return value is the simple change (in percent):

( newValue - oldValue ) / oldValue = change

Open in new window

just solve this for oldValue:

( newValue - oldValue ) / oldValue = change     | * oldValue
newValue - oldValue = change * oldValue         | + oldValue
newValue = change * oldValue + oldValue
newValue = oldValue ( change + 1 )              | / ( change + 1 )
newValue / ( change + 1 ) = oldValue

Open in new window


thus

=G8/(H8+1)

Open in new window

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial