| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formula cells needs to display "zero"
How do i get a cell with a formula in it to display a zero until a figure is
typed into a corresponding cell? All productive help is greatly appreciated. -- thank you |
|
#2
|
|||
|
|||
|
Assuming your formula is SUM(B1:B20), try: =IF(A1="",0,SUM(B1:B20)) Regards, KL "hello" wrote in message ... How do i get a cell with a formula in it to display a zero until a figure is typed into a corresponding cell? All productive help is greatly appreciated. -- thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pivot tables reports - altering display of (blank) cells | Excel Worksheet Functions | |||
| Display empty cells | Excel Discussion (Misc queries) | |||
| locking a formula to cells | Excel Discussion (Misc queries) | |||
| Applying formula to only NON-EMPTY cells in range | Excel Discussion (Misc queries) | |||
| Paste is is copying in formula, but display is wrong. | Excel Discussion (Misc queries) | |||
Linear Mode
