Thread: Zero Appears
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
reed0427 reed0427 is offline
external usenet poster
 
Posts: 6
Default Zero Appears

I changed the format from numbers to general. No change. Curses!
Dave

"Chip Pearson" wrote:

The first thing I would look at is the number formatting of the cell. Select
the cell, then go to the Format menu, choose Cells, click the Number tab,
and see how the cell is formatted. Try changing the format to General.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)

"reed0427" wrote in message
...
I have this formula in a cell on my spreadsheet:
=IF(C26F29,"OVERWEIGHT"," ")
Problem: A "0" (zero) appears in the cell regardless of whether the answer
is TRUE or FALSE. What gives?