G
Guest
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?
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?