View Single Post
  #1   Report Post  
CM
 
Posts: n/a
Default 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?