# reversing fomula

#### mond

##### New Member
A3 = 52.1847833333333
So will be B3 = 3665.0338
I wish to reverse the formula by writing on C3 = 3665.0338 and on D3 the answer will be 52.1847833333333

### Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
mond,
Welcome to the board.

Instead of reversing the formula, why not just use goalseek?

Mond, I have never used Goal Seek before and am trying to come to grips with it.

Not sure where to put the various figures to come up with the formula.
This was my amateurish attempt
Book1
ABCDE
1
2
352.18483665.032557.0652.1848
Sheet1

Pedro

hello Pedro,
why is D3 = C3/49?

what I was trying to say with "using goalseek" is:
let C3 be blank or any number (greater than equal to -90 and less than equal to 90) and D3 have this formula:

now goto Tools>>goal seek>>Select D3 as Set cell>>Type 3665.0338 in To Value>>select C3 as By Changing cell>>click ok>>see the results

Sorry c_m, I typed wrong name in my request.
Mondo that formula was because I thought I had to put any formula and the Goal seek would correct it.

Tried the suggested method but get a message "Goal seeking may not have found a solution"

This is the result on spreadsheet
GoalSeek.xls
ABCDE
1
2
3-335544-3.81667E-13
Sheet1

I started by inserting formula into D3 , selected Goal Seek and then in "Set cells" i entered D3.
Then typed the 3665 number into "To Value" and selected C3 for "Changing cells".

Where have I gone wrong?

Pedro

PROBLEM SOLVED.
i input the original formula with the reference to A3 . Changed it to C3 and all well .

Thanks

Pedro

Adding to that, it is possible that your goalseek or solver may not find solution to your problem. Its typical with non-linear composite functions. In this case, the solutions may have 5 real roots...so goalseek or solver may return any of the roots if the initial value is fairly close or in neighborhood of the root....otherwise it may return error of "no solutions found"...In order to get rid of this...i usually use solver with constraints on changing cell so that the solution converges instead of diverging.

Hi

This expression deals with trigonometric functions and may have an infinite number of solutions.

For ex., base on the solution 52.1847833333333 any number

52.1847833333333 + 360 * K

where K is any integer, positive or negative, ex:

K=1  solution: 412.1847833
K=-1 solution: -307.8152167

are also solutions.

hello there,
thanks for the immediate response to my problem, but what i liked to change is the formula on d3, which is the reverse formula on b3 so it will give answer base on c3 value.

thanks again.

Replies
1
Views
196
Replies
0
Views
201
Replies
7
Views
306
Replies
5
Views
699
Replies
2
Views
198

1,196,043
Messages
6,013,055
Members
441,746
Latest member
ArtemisAlex

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back