| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
place empty cell with zero
I am trying to place zero in place of empty cells in my worksheet, i used
formula =IF(A2="",0,A2) But this formula is also placing zero for a cell having value(number), i donot want the cells with values to be filled with zero, i want only empty cells in my sheet to be filled with zero. can anyone help me plz. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom format that shows blank cell if another cell is empty | Excel Discussion (Misc queries) | |||
| Text wider than one cell is not displayed in the next empty cell | Excel Discussion (Misc queries) | |||
| put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
| make a cell empty based on condition | Charts and Charting in Excel | |||
| cell that accepts a whole number or five place deciaml | Excel Worksheet Functions | |||
Threaded Mode
