Maybe you just wanted

=IF(OR(D16="",COUNTA(D17,D22,D26)=3),"",MIN(D17,D2 2,D26))


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

wrote in message
ps.com...
using my old code with IF(OR(D16="",COUNTBLANK(D17)+(D22)+D26)0) isn't
valid as a function code. Is there anyway to resolved this issue.

Cheers,

Ims

wrote:
Hi Bob,

The code doesn't seem to work. The results display blanks.
Stefi wrote:
Hi Robert,

For me XL2003 doesn't allow a non-contiguous range in COUNTA, what do I
do
wrong?

Regards,
Stefi

,,Robert McCurdy" ezt írta:

Apparently the only thing the formula is trying to do is find a MIN?

=IF(COUNTA(D17,D22,D26)=3,MIN(D17,D22,D26),"")


Regards
Robert McCurdy

wrote in message
ups.com...
Hi All,

Is there anyone that can help with this formula that I have been stuck
on for an while.


What I am trying to achieve is when D16 is blank the other cells are
blank and that equal D15 being blank. Also D15 must take D16 and the
Lowest value from the other cells.

FORMULA FOR CELL D15: -


=IF(OR(D16="",COUNTBLANK(D17)+(D22)+D26)0),"",IF( COUNTIF(D17)+COUNTIF(D22),
COUNTIF+(D26,D16)MIN(D1*7)+(D22)+(D26))))

Cheers

Ims