when a cell is empty do not consider it at all

[empty cell]

I have a program I made for points which I used (if and) format, which I will
enter a different number each time, where the empty cell I don't want to be
considered as zero

thank you

[davesexcel]

lets see the formula

[Tom Ogilvy]

You can check if a cell is empty with

for each cell in Range("A1:A10")
if isempty(cell) then
' cell is empty
else
' cell is not empty
end if
Next

--
Regards,
Tom Ogilvy

"empty cell" <empty [email protected]> wrote in message
news:[email protected]...
> I have a program I made for points which I used (if and) format, which I
will
> enter a different number each time, where the empty cell I don't want to
be
> considered as zero
>
> thank you