Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Regression Leverage Formula (Jerry W. Lewis or Mike Middleton)already have DFITS formula | Excel Worksheet Functions | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
Formula expected end of statement error, typing formula into cell as part of VBA macro | Excel Programming | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
Commenting custom formula fields/formula on formula editor | Excel Programming |