| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
In Excel, show 0.00 for "zero" entries, but "-" if no entries
I need to distinguish between no entry in a cell, and a zero (0.00) entry,
and whn I sum the row, know if there were any entries (even 0.00) or no entries. I would like to show 0.00 if there entries (or the actual sum) and a dash ("-") if there were no entries. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
In Excel, show 0.00 for "zero" entries, but "-" if no entries
=IF(COUNT(A1:A6),SUM(A1:A6),"-")
replace A1:A6 with your range. "PLS Auditor" wrote: I need to distinguish between no entry in a cell, and a zero (0.00) entry, and whn I sum the row, know if there were any entries (even 0.00) or no entries. I would like to show 0.00 if there entries (or the actual sum) and a dash ("-") if there were no entries. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| EXCEL allow 2 options on status bar e.g. show "Count" + "Sum" | Excel Discussion (Misc queries) | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| conditional formula to show "open" or "closed" | Excel Worksheet Functions | |||
Linear Mode
