A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

zero value in cell



 
 
Thread Tools Display Modes
  #1  
Old May 28th, 2010, 08:48 PM posted to microsoft.public.excel.worksheet.functions
Arthur
external usenet poster
 
Posts: 55
Default 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  
Old May 28th, 2010, 10:13 PM posted to microsoft.public.excel.worksheet.functions
Gord Dibben
external usenet poster
 
Posts: 20,252
Default 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  
Old May 28th, 2010, 11:06 PM posted to microsoft.public.excel.worksheet.functions
Arthur
external usenet poster
 
Posts: 55
Default 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

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:22 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.