Prev: Need to do a data check - not sure the best way.
Next: Hold a cell range for an "average formula"
From: Arthur on 28 May 2010 15:48
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
From: Gord Dibben on 28 May 2010 17:13
I'm guessing your numbers are actually Text.

Format all to general.

Copy an empty cell.

Select the range of numbers and paste special>add>ok>esc.


Gord Dibben MS Excel MVP

On Fri, 28 May 2010 12:48:01 -0700, Arthur
<Arthur(a)discussions.microsoft.com> 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?

From: Arthur on 28 May 2010 18:06
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
 | 
Pages: 1
Prev: Need to do a data check - not sure the best way.
Next: Hold a cell range for an "average formula"