Help with an formula
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
|