Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I hide the zero in the "sum" cell until numbers are put in the cells that are being added?
I have 4 cells, A-D. Cell D is the "sum" cell. Cell D will show a "0" on the spreadsheet if nothing is inputed into any of the 3 other cells. How do i write the formula in cell D so that the "0" does not show on the spreadsheet until numbers are put into any or all of cells A-C? Radman |
#2
|
|||
|
|||
One way, in D1:
=IF(COUNTBLANK(A1:C1)=3,"",SUM(A1:C1)) -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "Radman" wrote in message ... I have 4 cells, A-D. Cell D is the "sum" cell. Cell D will show a "0" on the spreadsheet if nothing is inputed into any of the 3 other cells. How do i write the formula in cell D so that the "0" does not show on the spreadsheet until numbers are put into any or all of cells A-C? Radman |
#3
|
|||
|
|||
One way:
=IF(COUNT(A1:C1)=0,"",SUM(A1:C1)) In article , Radman wrote: I have 4 cells, A-D. Cell D is the "sum" cell. Cell D will show a "0" on the spreadsheet if nothing is inputed into any of the 3 other cells. How do i write the formula in cell D so that the "0" does not show on the spreadsheet until numbers are put into any or all of cells A-C? Radman |
#4
|
|||
|
|||
You could put in an equation where NA() is entered if the values entered in
A-C are blank. You could then conditionally format column D so that NA() is formatted in the same color as the background. "Radman" wrote in message ... I have 4 cells, A-D. Cell D is the "sum" cell. Cell D will show a "0" on the spreadsheet if nothing is inputed into any of the 3 other cells. How do i write the formula in cell D so that the "0" does not show on the spreadsheet until numbers are put into any or all of cells A-C? Radman |
#5
|
|||
|
|||
Can a grumpy old ex-prof have a rant on this wet Saturday afternoon?
An enter such a =SUM(A1:A10) is a FORMULA. A mathematical expression such as y=4x^2 + 4 is an EQUATION. If we use the wrong terminology we will not find what we need in Help. Happy Canadian Thanksgiving! -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Barb Reinhardt" wrote in message ... You could put in an equation where NA() is entered if the values entered in A-C are blank. You could then conditionally format column D so that NA() is formatted in the same color as the background. "Radman" wrote in message ... I have 4 cells, A-D. Cell D is the "sum" cell. Cell D will show a "0" on the spreadsheet if nothing is inputed into any of the 3 other cells. How do i write the formula in cell D so that the "0" does not show on the spreadsheet until numbers are put into any or all of cells A-C? Radman |
#6
|
|||
|
|||
Another option.....
Use a custom format to suppress the display of zero: 0;-0;;@ Biff "Radman" wrote in message ... I have 4 cells, A-D. Cell D is the "sum" cell. Cell D will show a "0" on the spreadsheet if nothing is inputed into any of the 3 other cells. How do i write the formula in cell D so that the "0" does not show on the spreadsheet until numbers are put into any or all of cells A-C? Radman |
#7
|
|||
|
|||
Hi,
You may also use conditional formatting. Go to FormatConditional formatting and sekect cell valueEqual t0=0. Now select the font as White Regards, Ashish Mathur "Radman" wrote: I have 4 cells, A-D. Cell D is the "sum" cell. Cell D will show a "0" on the spreadsheet if nothing is inputed into any of the 3 other cells. How do i write the formula in cell D so that the "0" does not show on the spreadsheet until numbers are put into any or all of cells A-C? Radman |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copying cell names | Excel Discussion (Misc queries) | |||
In Excel is it possible to hide a row condtional upon a cell val.. | Excel Discussion (Misc queries) | |||
Hide cell content in printing | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Hide hyperlink cell & replace with macros | Excel Worksheet Functions |