#DIV/0! Is there a way to suppress this display when no data is entere?

[Clueless in Seattle]

I'm using Excel to track my expenses so I can find ways to reduce
them.

I enter the data from all my retail receipts into a spread sheet that
includes columns to compute the "price per unit" for some items. This
is very handy for comparing the per dose cost of medications, or the
per ounce cost of items in different sized containers.

My approach is very straightforward; I've set up three columns like
this:

Price Units Unit Price

In the "Unit Price" cells I have the formula =sum(Price/Units)

But now all the cells in the "Unit Price" column display #DIV/0!

Is there a way to include an instruction in the formula to tell Excel
that if there are no values or a value of zero in the referenced
columns to just leave the "Unit Price" column blank instead of
displaying that distracting and annoying #DIV/0!?

 

[Karl]

if(a2="","",price/unit) will only calc if something in a2

 

[Bob Umlas]

Select all the cells
Use Format/Conditional formatting
Change "Cell Value Is" to "Formula Is"
assuming A1 is the active cell, enter
=ISERROR(A1)
then click the Format button, then the Font Tab
Change the font to white.
OK your way out.
That's it --
Bob Umlas
Excel MVP

 

[Earl Kiosterud]

Bob,

One potential problem is that if this formula is a precedent to any other
formulas, the error will propagate, blowing out the others.