Home |
Search |
Today's Posts |
#1
|
|||
|
|||
try
=IF(formula=0, [spacebar], formula) and by [spacebar], I mean just leave it empty "samerry" wrote in message ... I have copied a formula down several rows for future data to be entered and calculated. In the formula column it shows "0". I would like for the "0" not to show. Does anyone know how to make the "0" go away without deleting the formula. Data will later be entered in the appropriate rows and need to be calculated at the appropriate time. |
#2
|
|||
|
|||
How do you get rid of 0 when data not in formula row yet?
I have copied a formula down several rows for future data to be entered and
calculated. In the formula column it shows "0". I would like for the "0" not to show. Does anyone know how to make the "0" go away without deleting the formula. Data will later be entered in the appropriate rows and need to be calculated at the appropriate time. |
#3
|
|||
|
|||
Us an IF statement in your formula.
=IF(A1="","",formula) HTH, Paul "samerry" wrote in message ... I have copied a formula down several rows for future data to be entered and calculated. In the formula column it shows "0". I would like for the "0" not to show. Does anyone know how to make the "0" go away without deleting the formula. Data will later be entered in the appropriate rows and need to be calculated at the appropriate time. |
#4
|
|||
|
|||
You could also use Joe's formula, but I believe you'll need to use a two
double quotes instead of a space. =IF(formula=0,"",formula) "PCLIVE" wrote in message ... Us an IF statement in your formula. =IF(A1="","",formula) HTH, Paul "samerry" wrote in message ... I have copied a formula down several rows for future data to be entered and calculated. In the formula column it shows "0". I would like for the "0" not to show. Does anyone know how to make the "0" go away without deleting the formula. Data will later be entered in the appropriate rows and need to be calculated at the appropriate time. |
#5
|
|||
|
|||
Make a custom format and use this as your format type...
# "samerry" wrote: I have copied a formula down several rows for future data to be entered and calculated. In the formula column it shows "0". I would like for the "0" not to show. Does anyone know how to make the "0" go away without deleting the formula. Data will later be entered in the appropriate rows and need to be calculated at the appropriate time. |
#6
|
|||
|
|||
Do I add this to the =SUM formula in the same cell?
"PCLIVE" wrote: You could also use Joe's formula, but I believe you'll need to use a two double quotes instead of a space. =IF(formula=0,"",formula) "PCLIVE" wrote in message ... Us an IF statement in your formula. =IF(A1="","",formula) HTH, Paul "samerry" wrote in message ... I have copied a formula down several rows for future data to be entered and calculated. In the formula column it shows "0". I would like for the "0" not to show. Does anyone know how to make the "0" go away without deleting the formula. Data will later be entered in the appropriate rows and need to be calculated at the appropriate time. |
#7
|
|||
|
|||
Yes,
Example: =IF(SUM(A1:A3)=0,"",SUM(A1:A3)) This basically states that if your formula results "0", then the cell remains blank, otherwise display the results of your formula. Paul "samerry" wrote in message ... Do I add this to the =SUM formula in the same cell? "PCLIVE" wrote: You could also use Joe's formula, but I believe you'll need to use a two double quotes instead of a space. =IF(formula=0,"",formula) "PCLIVE" wrote in message ... Us an IF statement in your formula. =IF(A1="","",formula) HTH, Paul "samerry" wrote in message ... I have copied a formula down several rows for future data to be entered and calculated. In the formula column it shows "0". I would like for the "0" not to show. Does anyone know how to make the "0" go away without deleting the formula. Data will later be entered in the appropriate rows and need to be calculated at the appropriate time. |
#8
|
|||
|
|||
Go into Tools--Options--View and uncheck Show Zero Values. This should work.
I use it all the time in complex pivot tables, etc. "samerry" wrote: I have copied a formula down several rows for future data to be entered and calculated. In the formula column it shows "0". I would like for the "0" not to show. Does anyone know how to make the "0" go away without deleting the formula. Data will later be entered in the appropriate rows and need to be calculated at the appropriate time. |
#9
|
|||
|
|||
You could use Tools...Options...View and uncheck the Zero Values box, but
that may not be what you want if you need to see zero values when the data is entered... "samerry" wrote in message ... I have copied a formula down several rows for future data to be entered and calculated. In the formula column it shows "0". I would like for the "0" not to show. Does anyone know how to make the "0" go away without deleting the formula. Data will later be entered in the appropriate rows and need to be calculated at the appropriate time. |
#10
|
|||
|
|||
Also Custom format works like this...
Postive numbers;Negative Numbers;Zero So if you want it to show decimal points, then you would need something like this as a custom format... #.00;#.00;"" If you are dealing with whole numbers, this isn't necessary and # by itself will be appropiate. "Sloth" wrote: Make a custom format and use this as your format type... # "samerry" wrote: I have copied a formula down several rows for future data to be entered and calculated. In the formula column it shows "0". I would like for the "0" not to show. Does anyone know how to make the "0" go away without deleting the formula. Data will later be entered in the appropriate rows and need to be calculated at the appropriate time. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
ENTER A FORMULA IN A CELL TO UTILIZE THE IMPORT DATA FUNCTIONS? | Excel Worksheet Functions | |||
Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) | |||
matching data formula? | Excel Worksheet Functions |