| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Keeping a cell value constant trhoughout a list of values | Excel Worksheet Functions | |||
| Count Intervals of 2 Consecutive Values in same Row and Return Count across Row | Excel Worksheet Functions | |||
| I Need a formula to evaluate a cell with + or - values | Excel Worksheet Functions | |||
| Return Range of Numerical Values in Single Column based on Frequency Percentage | Excel Worksheet Functions | |||
| #N/A Values : Returned by Formulas vs Entered Manually | Charts and Charting in Excel | |||
Threaded Mode
