when a cell is empty do not consider it at all
 

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

when a cell is empty do not consider it at all
 

lets see the formula


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=531219

when a cell is empty do not consider it at all
 

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 wrote in message
...
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