Sun, 7 Mar 2010 18:13:01 -0800 from painter50 <painter50
@discussions.microsoft.com:

I get this #DIV/O! when I divide two cell that both total 0.

These cell will not always be used in the spreadsheet. Is there any way to
show the total of these cell to be 0 when not used?

=if(A2,A1/A2,0)

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
Shikata ga nai...