If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
copying cell names | Al | General Discussion | 3 | August 11th, 2005 03:01 PM |
hide cell contents and make it reappear (Excel) | Dave | General Discussion | 3 | April 15th, 2005 09:00 PM |
How to hide Hypyerlink cell contents ? | Wellie | General Discussion | 2 | October 2nd, 2004 03:30 PM |
IF only.....IF only.... | SmokingMirror | Worksheet Functions | 8 | August 7th, 2004 07:37 PM |
Hide certain information within a cell when printing | jeremy | General Discussion | 2 | June 12th, 2004 03:52 PM |