Use

=IF(A1="","",A1)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"WGeorg" wrote in message
...
if A1=Null and B1=A1 why is result in B1=0 ??
because of this I get wrong result for average calculations: average for
(6,8,0) < average for (6,8,null)