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

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

" wrote:

On Nov 28, 8:12 pm, reed0427
wrote:
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?


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

ed