View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] ims121uk@gmail.com is offline
external usenet poster
 
Posts: 48
Default Help with an formula

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