Formula Results
 

All my formula results display a 0 in the cell. I see the correct result in
the Formula Argument box. The cell format is general. And I have the same
result with IF formula or VLookup.
--
Fluteplayer

Formula Results
 

I would check the formats that are assigned to all the cells displaying
zeroes, to rule out an errant format assignment.

--
Kevin Backmann


"Fluteplayer" wrote:

All my formula results display a 0 in the cell. I see the correct result in
the Formula Argument box. The cell format is general. And I have the same
result with IF formula or VLookup.
--
Fluteplayer

Formula Results
 

If the data are numbers, perhaps they have been entered as Text?

Copy an empty cell.

Select the range of "numbers" and EditPaste SpecialAddOKEsc.

If not the above then post some sample data and a formula or two.


Gord Dibben MS Excel MVP

On Fri, 6 Jun 2008 10:12:01 -0700, Fluteplayer
wrote:

All my formula results display a 0 in the cell. I see the correct result in
the Formula Argument box. The cell format is general. And I have the same
result with IF formula or VLookup.