I
ims121uk
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(D17)+(D22)+(D26))))
Cheers
Ims
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(D17)+(D22)+(D26))))
Cheers
Ims