# Solving simple equasion

on
EE Pros,

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

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

Do more with

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)
``````
Where G8 is Selling Price x 100 / 100 + H8 as Profit(%) x 100
Check in attached...
Solve-Reverse-Eq.xlsx

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.
Managing Director/Excel VBA Developer
Distinguished Expert 2018

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

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

``````( newValue - oldValue ) / oldValue = change
``````
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
``````

thus

``````=G8/(H8+1)
``````

Do more with