alpinescott
New Member
- Joined
- Sep 24, 2004
- Messages
- 48
hello,
i've run into a formatting problem (i think) that won't allow me to run a calculation that uses a cell ref. as an exponent.
here's what i've got:
the value that i'm trying to raise to the nth power is the result of this formula:
=((10*(AM3))/AO14) gives me this value (-4.479)
the exponent "a" is a result of this formula:
=(0.49+0.0179*(AO14)-(0.0000771*(AO14)^2)+(0.000000675*(AO14)^3))
gives me this value (.7962)
so the formula that's giving me troubles is
=(AR3)^AQ14
i've tried changing the formatting of both to numbers, the exponent "a" to a fraction, copying and pasting values to remove the formula ref. etc. and nothing works. when i enter the values into the formula (has to be both, not one value and one cell ref. i tried this too and it doesn't work) it will return the proper value. has anyone run across this problem before?
thanks, scott
i've run into a formatting problem (i think) that won't allow me to run a calculation that uses a cell ref. as an exponent.
here's what i've got:
the value that i'm trying to raise to the nth power is the result of this formula:
=((10*(AM3))/AO14) gives me this value (-4.479)
the exponent "a" is a result of this formula:
=(0.49+0.0179*(AO14)-(0.0000771*(AO14)^2)+(0.000000675*(AO14)^3))
gives me this value (.7962)
so the formula that's giving me troubles is
=(AR3)^AQ14
i've tried changing the formatting of both to numbers, the exponent "a" to a fraction, copying and pasting values to remove the formula ref. etc. and nothing works. when i enter the values into the formula (has to be both, not one value and one cell ref. i tried this too and it doesn't work) it will return the proper value. has anyone run across this problem before?
thanks, scott