It depends on what kind of calculation you're doing but normally an empty
cell evaluates as 0.

If you need the 0s then you can just fill the empty cells with 0.

Let's assume your range is A1:A10 with some empty cells.
Select the range A1:A10
Hit function key F5SpecialBlanksOK
Type a 0 then, while holding down the CTRL key hit ENTER

All the empty cells in the range will be filled with 0.

--
Biff
Microsoft Excel MVP


"Tim" wrote in message
...
I am uploading values from an existing data base. Sometimes there is no
items
sold during the time so it just gives me a blank area. I need to change
that
to a zero so it will calculate correctly. I have tried @if statements but
am
getting no results sinve the area is blank to begin with. All i need is a
statement that says if the area is blank result =0, or the number that is
there.

Thanks for any help.