Would help to see your formula, but:
=if(isblank(a1),"",a1*b1)
************
Anne Troy
VBA Project Manager
www.OfficeArticles.com

"thomson" wrote in message
...
I am creating a spreadsheet dealing with dollars. There are several
formulas
that I have created using percentages. One particular formula multiplies
a
percent in one cell by the $ value in another. If I have no $ value in
the
cell the formula uses a '1' instead of what I would expect '0'. How can I
set up my sheet so that if a cell is blank the default value will be '0'?