Zero Appears

  • Thread starter Thread starter reed0427
  • Start date Start date
R

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?
 
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)
 
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?
Click to expand...

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

ed
 
Back
Top