Replace "" with "0" and see threresult ....
IF(ISERROR(IF(MIN(IF(Sheet1!$F$3:$F$35C27,Sheet1! $F$3:$F$35))=0,"",MIN(IF(Sheet1!$F$3:$F$35C27,She et1!$F$3:$F$35)))),"[/color]",
willemeulen;351337 Wrote:
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?
--
mubashir aziz
If this post helps Don't 4get to click Yes
------------------------------------------------------------------------
mubashir aziz's Profile:
http://www.thecodecage.com/forumz/member.php?userid=237
View this thread:
http://www.thecodecage.com/forumz/sh...ad.php?t=98209