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

--
HTH

Bob Phillips

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

wrote in message
oups.com...
Hi Robert,

That works but a small problem with the code not counting blanks. As
well when D16 is blank and the other fields are filled D15 should be
blank not 0. I have tried my first part of my code but that doesn't
work.

many thanks

Robert McCurdy wrote:
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