Thread: Custum Cell Format - display 0 (zero) when cell is empty
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
willemeulen[_18_] willemeulen[_18_] is offline
external usenet poster
  
Posts: 1
Default Custum Cell Format - display 0 (zero) when cell is empty

I change the formala from the second cell as follows:

=IF(ISERROR(IF(MIN(IF(Sheet1!$F$3:$F$35C27,Sheet1 !$F$3:$F$35))=0,"",MIN(IF(Sheet1!$F$3:$F$35C27,Sh eet1!$F$3:$F$35)))),"",IF(MIN(IF(Sheet1!$F$3:$F$35 C27,Sheet1!$F$3:$F$35))=0,"",MIN(IF(Sheet1!$F$3:$ F$35C27,Sheet1!$F$3:$F$35))))

But there are no 0 (zero's) displayed.

Is it not possible with the custom format of the cell, as this will not
affect the formula at all, or will excell still read nothing?


--
willemeulen

Blink1 *Willem van der Meulen* BSc Soil & Water Eng (Netherlands)
------------------------------------------------------------------------
willemeulen's Profile: http://www.thecodecage.com/forumz/member.php?userid=285
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=98209

Reply With QuoteReply With Quote