Cells

's Computer Specifications

Q1) How do i get a cell to show/display zero when no data has been input or
when the dat has been deleted.

Q2)how do i get a cell to display 0 instead of #DIV/0!

's Computer Specifications

David,

Hide the error with
=IF(ISERROR(A1/B1),0,A1/B1)

Miek

"David" wrote:

> Q1) How do i get a cell to show/display zero when no data has been input or
> when the dat has been deleted.
>
> Q2)how do i get a cell to display 0 instead of #DIV/0!

's Computer Specifications

Check to see if the denominator is zero first:
=if(a1=0,"",b1/a1)

or check for an error
=if(iserror(b1/a1),"",b1/a1)

David wrote:
>
> Q1) How do i get a cell to show/display zero when no data has been input or
> when the dat has been deleted.
>
> Q2)how do i get a cell to display 0 instead of #DIV/0!

--

Dave Peterson

's Computer Specifications

Oops, you wanted 0's.

#1. You can't.

#2. Check to see if the denominator is zero first:
=if(a1=0,0,b1/a1)

or check for an error
=if(iserror(b1/a1),0,b1/a1)

David wrote:
>
> Q1) How do i get a cell to show/display zero when no data has been input or
> when the dat has been deleted.
>
> Q2)how do i get a cell to display 0 instead of #DIV/0!

--

Dave Peterson

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
That document contains too many cells. At this time, spreadsheets inGoogle Docs only support up to 400000 cells	Mark	Microsoft Excel Misc	0	19th Jan 2011 03:08 PM
copy an intial cells contents into the next series of blank cells ina column	freeriderxlt	Microsoft Excel Discussion	2	25th Aug 2009 07:47 AM
Excel: match two cells in one sheet to two cells in another and return a third cells value	Spence	Microsoft Excel Worksheet Functions	2	19th Jul 2005 04:19 AM
Skip cells with TAB/SHIFT+TAB but allow arrow keys/mouse selection of skipped cells	Wescotte	Microsoft Excel Programming	1	6th Jun 2005 07:00 PM
A calculation to count all cells ='D' where the offset cells in range have dates <= todays date	AlanN	Microsoft Excel Misc	2	29th Jan 2004 03:57 PM