Would this help? I was looking at your part that says...
"...if another cell is blank or zero."...
=IF(OR(ISBLANK(C1),C1=0),"",MIN(A1:B10))
HTH
--
Dana DeLouis
Win XP & Office 2003
"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?
|