| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Zero Appears
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) "reed0427" wrote in message ... 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Zero Appears
I changed the format from numbers to general. No change. Curses!
Dave "Chip Pearson" wrote: 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) "reed0427" wrote in message ... 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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| My file is 20MB but there appears to be nothing in it. | Excel Discussion (Misc queries) | |||
| In Excel ### appears in the cell, not the sum. Why? | New Users to Excel | |||
| 10 million appears as 10,000,000.00 | Excel Discussion (Misc queries) | |||
| Why sometimes I try to use "=" and it appears "pts"?? | Excel Discussion (Misc queries) | |||
| Formula appears instead of value | Excel Discussion (Misc queries) | |||
Linear Mode
