Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
zero value in cell
I have a table of engineering calculations. The same formula in each cell
operation on variables in the row and column headers. i use the MIN function to evaluate two formulas. Then I take the minimum result and operate on it outside of hte MIN function. I'm getting zero values displaying in my table. When I pick a particular cell, and then pick the formula icon in the editor, the dialog box displays the correct reults for each of the two items and the formula overall. Why don't these results show in my table? -- Arthur |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
zero value in cell
I'm guessing your numbers are actually Text.
Format all to general. Copy an empty cell. Select the range of numbers and paste specialaddokesc. Gord Dibben MS Excel MVP On Fri, 28 May 2010 12:48:01 -0700, Arthur wrote: I have a table of engineering calculations. The same formula in each cell operation on variables in the row and column headers. i use the MIN function to evaluate two formulas. Then I take the minimum result and operate on it outside of hte MIN function. I'm getting zero values displaying in my table. When I pick a particular cell, and then pick the formula icon in the editor, the dialog box displays the correct reults for each of the two items and the formula overall. Why don't these results show in my table? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
zero value in cell
Nevermind. I found an error in the sheet that the formulas depended upon but
did not show an error. -- Arthur "Arthur" wrote: I have a table of engineering calculations. The same formula in each cell operation on variables in the row and column headers. i use the MIN function to evaluate two formulas. Then I take the minimum result and operate on it outside of hte MIN function. I'm getting zero values displaying in my table. When I pick a particular cell, and then pick the formula icon in the editor, the dialog box displays the correct reults for each of the two items and the formula overall. Why don't these results show in my table? -- Arthur |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing Options | Excel Discussion (Misc queries) | |||
Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing | Excel Discussion (Misc queries) | |||
Populate a cell if values in cell 1 and cell 2 match cell 3 and 4 | Excel Worksheet Functions | |||
How to create/run "cell A equals Cell B put Cell C info in Cell D | Excel Discussion (Misc queries) | |||
Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) |