| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
0 entry vs blank cell
Is there a way to have Excel know the differance between a 0 entry and a
blank cell? I am trying to mask a blank cell (input data cell) that is referenced in a formula (output cell) so that it returns a blank, but if a 0 is entered into the input cell I want the 0 to be shown in output cell. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
0 entry vs blank cell
Something like
IF(ISBLANK(A1),"",A1) "Motion" wrote: Is there a way to have Excel know the differance between a 0 entry and a blank cell? I am trying to mask a blank cell (input data cell) that is referenced in a formula (output cell) so that it returns a blank, but if a 0 is entered into the input cell I want the 0 to be shown in output cell. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
0 entry vs blank cell
Hi Motion,
IsBlank(yourcell) will produce True if the cell is blank, and will produce False if the cell is 0 ... HTH Cheers Carim |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
0 entry vs blank cell
=if(a1="","",a1)
Motion wrote: Is there a way to have Excel know the differance between a 0 entry and a blank cell? I am trying to mask a blank cell (input data cell) that is referenced in a formula (output cell) so that it returns a blank, but if a 0 is entered into the input cell I want the 0 to be shown in output cell. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Blank cell return after each data entry | Excel Discussion (Misc queries) | |||
| Data Entry - Write to next cell & next blank line | Excel Worksheet Functions | |||
| restricting entry into a cell based on entry to a previous cell | New Users to Excel | |||
| Cell Entry That Locks Selected Cells From Any Data Entry. | Excel Worksheet Functions | |||
| Replace (blank) entry in a pivot report with clear cell | Excel Discussion (Misc queries) | |||
Linear Mode
