Do you mean

=IF(X1="","",MIN(A1:A10,B1:B10))

--

HTH

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


"CM" wrote in message
...
I am using =min(a1:a10,b1:b10)to return the min number in two fields,
however
i want the cell to remain blank or return "0" if another cell is blank or
zero. Can anbody help?