formula results into zero

  • Thread starter Thread starter jomni
  • Start date Start date
J

jomni

My officemate has experienced the following:

When she adds two cells, the result shown in the cell is zero.
But when you press F2 you can see the correct result.
What is the cause of this? Even changing the cell format does not
work.

The file size is actually about 6MB... maybe that has something to do
about it.:confused:
 
Hi

Can you post the formula that is being used and the values of the
referenced cells? Pushing F2, while in the cell, should only put you
into Edit Mode and show the Formula, not the result.

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****
 
It's just a simple addition. Cell1 + Cell2. I'm wrong about pressin
F2. It's actually meant pressing F2 then F9. Anyway it's probably
circular reference. Thanks anyway
 
If you press F9 while in Edit mode, Excel performs the calculation and saves
the numeric result. To avoid this, after pressing F9, tap the ESC key.
Best wishes Bernard
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel is giving me zeros 3
The word "zero" appeared in a cell. 2
Excel JUMP FROM SEARCH BAR TO RESULT 3
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
Adding recognised Zeros 5
Copy cell formula returns zero instead of cell value 1
SUMing small numbers 6
Minus Zero 11

Back
Top