- #1
sara_87
- 763
- 0
Homework Statement
I have the formula
S=t^(-1/b)*g
I want to type this into excel.
Homework Equations
The Attempt at a Solution
For S are values typed into the second column (B)
for t are values typed into column A.
I 'named' the b and g using the name manager and set the initial values as 1.
then in the column C i want the predicted values for S so to get the first predicted value, i typed:
=g*(A2^(-1/b))
but i kept getting the #VALUE error and i don't know what's wrong with =g*(A2^(-1/b))
Thank you