Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default Zero Appears

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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
My file is 20MB but there appears to be nothing in it. excel_wizard Excel Discussion (Misc queries) 2 July 17th 07 07:51 PM
In Excel ### appears in the cell, not the sum. Why? BYT New Users to Excel 1 April 25th 07 05:54 PM
10 million appears as 10,000,000.00 ravi Excel Discussion (Misc queries) 1 September 3rd 06 01:54 PM
Why sometimes I try to use "=" and it appears "pts"?? Francisco Excel Discussion (Misc queries) 1 March 2nd 05 08:37 PM
Formula appears instead of value Pat Excel Discussion (Misc queries) 2 January 27th 05 11:30 PM


All times are GMT +1. The time now is 07:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"