Thread: I want to return "0" based on another cell

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?

Do you mean

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

--

HTH

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


"CM" <CM@discussions.microsoft.com> wrote in message
news:0156F04D-9CC3-420A-80C1-01689DA196E5@microsoft.com...
> 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?

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" <CM@discussions.microsoft.com> wrote in message
news:0156F04D-9CC3-420A-80C1-01689DA196E5@microsoft.com...
>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?