Getting wrong values
I'm missing something simple, but I am trying to get a value (displayed as a
percentage) in one cell, using the cell next to it as part of the equation.
The problem is that the second cell is displaying a value from an equation
that's built inside of it and when I use it for the first cell, I get a wrong
value.
I have cells B8 & C8.
Inside of B8 I want to display the value (as a %) while using cell C8 as
part of the equation. ex (B8 = C8/6).
However, C8 has an equation related to some other cells. (C8 =
Average(D8:AA8).
In other words, the value that is displayed in C8 (Which is "5.8") is the
number that I want to use for the equation in B8, however, I'm getting the
wrong answer.
What can I do to use only the value in C8 for the equation in B8?
|