Zero Appears

[reed0427]

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

 

[Chip Pearson]

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)

 

[ed]

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

I just did it and it works regardless of what the cell is formatted.

ed

 

[reed0427]

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

 

[reed0427]

Ah, problem discovered. I had an
error in a related cell. Thanks guys!