| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell with value returns that value, empty cell returns zero
How do I: If a cell contains a value, that cell shows that value. If that
cell is empty, that cell shows zero |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cell with value returns that value, empty cell returns zero
=IF(A1="",0,A1)
-- David Biddulph "tamarak" wrote in message ... How do I: If a cell contains a value, that cell shows that value. If that cell is empty, that cell shows zero |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
cell with value returns that value, empty cell returns zero
Hi,
At the cell, other than A1, write - =IF(A1,A1,0) Thankyou, Shail David Biddulph wrote: =IF(A1="",0,A1) -- David Biddulph "tamarak" wrote in message ... How do I: If a cell contains a value, that cell shows that value. If that cell is empty, that cell shows zero |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Empty Date Cell as Zero | Excel Discussion (Misc queries) | |||
| Blank (empty) cell always equal to 0?? | Excel Discussion (Misc queries) | |||
| =CELL("filename") VOLATILE? | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Using Jet to read excel file returns blank for last cell - sometim | Excel Discussion (Misc queries) | |||
Linear Mode
