michaelsmith559
Well-known Member
- Joined
- Oct 6, 2013
- Messages
- 881
- Office Version
- 2013
- 2007
In excel, I have a starting value in J371. Starting in K371 I have this formula: "=J371^(1/10)". L371 contains this formula: "=k371^(1/10)". And so on.
The list of values is below. My question is, as long as there is a formula in the cells, I can reverse the operations to get back to the starting value.
I could start in S372 with this formula: "=T371^10" and get the 1.000000000042070 and continue on all the way back to the original value. However,
if I take the ending value 1.00000000000421 by itself and raise it ^10 it does not give me 1.000000000042070. I want to know why. I'm asking because if
I format the cell, there is only zeroes after the 1. Is there a way to start with the ending value and get back to the original value if there are no
formulas in the cells to get to that value? To ask another way, Why can't I start with the value in T371 by itself (no formula), raise it to ^10 and get
the value of S371 and so on? Thanks for any help.
J371 = 1.042964685342690
K371 = 1.00421559238756
L371 = 1.000420761662500
M371 = 1.000042068201560
N371 = 1.000004206740520
O371 = 1.000000420673260
P371 = 1.000000042067320
Q371 = 1.000000004206730
R371 = 1.000000000420670
S371 = 1.000000000042070
T371 = 1.00000000000421
Mike
The list of values is below. My question is, as long as there is a formula in the cells, I can reverse the operations to get back to the starting value.
I could start in S372 with this formula: "=T371^10" and get the 1.000000000042070 and continue on all the way back to the original value. However,
if I take the ending value 1.00000000000421 by itself and raise it ^10 it does not give me 1.000000000042070. I want to know why. I'm asking because if
I format the cell, there is only zeroes after the 1. Is there a way to start with the ending value and get back to the original value if there are no
formulas in the cells to get to that value? To ask another way, Why can't I start with the value in T371 by itself (no formula), raise it to ^10 and get
the value of S371 and so on? Thanks for any help.
J371 = 1.042964685342690
K371 = 1.00421559238756
L371 = 1.000420761662500
M371 = 1.000042068201560
N371 = 1.000004206740520
O371 = 1.000000420673260
P371 = 1.000000042067320
Q371 = 1.000000004206730
R371 = 1.000000000420670
S371 = 1.000000000042070
T371 = 1.00000000000421
Mike