Thread: Zero Appears
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
ed ed is offline
external usenet poster
 
Posts: 82
Default Zero Appears

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