excellover1
New Member
- Joined
- Mar 7, 2011
- Messages
- 1
Ive got the following formula in Excel:
=DEGREES(ACOS(SIN(RADIANS($B$3))*SIN(RADIANS(W2))+COS(RADIANS($B$3))*COS(RADIANS(W2))*COS(RADIANS(AF2))))
The values are:
$B$3=40.633
W2=-23.371
AF1=-177.339
to make it easier for you guys, this is the order it executes:
[1]. SIN(RADIANS($B$3))*SIN(RADIANS(W2))
[2]. COS(RADIANS($B$3))*COS(RADIANS(W2))
[3]. [2]*COS(RADIANS(AF2))
[4]. [1]*[3]
[5]. ACOS([4])
[6]. DEGREES([5])
Result (R): 162.59
Great.
I now want to rearrange the formula, to work backwards. How should the formula look if I want to put AF2 on the other side of the equals (and thereby making the result tell me AF2)? And how should it look if I want to put W2 on the other side of the equals?
Thanks in advance.
=DEGREES(ACOS(SIN(RADIANS($B$3))*SIN(RADIANS(W2))+COS(RADIANS($B$3))*COS(RADIANS(W2))*COS(RADIANS(AF2))))
The values are:
$B$3=40.633
W2=-23.371
AF1=-177.339
to make it easier for you guys, this is the order it executes:
[1]. SIN(RADIANS($B$3))*SIN(RADIANS(W2))
[2]. COS(RADIANS($B$3))*COS(RADIANS(W2))
[3]. [2]*COS(RADIANS(AF2))
[4]. [1]*[3]
[5]. ACOS([4])
[6]. DEGREES([5])
Result (R): 162.59
Great.
I now want to rearrange the formula, to work backwards. How should the formula look if I want to put AF2 on the other side of the equals (and thereby making the result tell me AF2)? And how should it look if I want to put W2 on the other side of the equals?
Thanks in advance.