| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help with an formula
Your question is not clear enough! I guess that the first part of it requests
that IF D16 is blank AND either of D17,D22,D26 is blank THEN D15 should be blank, but the ELSE branch is not clear (perhaps in one case D15 should be the Lowest value of D17,D22,D26, and in another case D15 should be equal to D16, but there is no criterium given to differentiate these cases). Give an example! Regards, Stefi € ezt Ã*rta: 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help with an formula
Yeah D15 should be the lowest value of D17, D22, D26. That Rights!
Thanks Ims Stefi wrote: Your question is not clear enough! I guess that the first part of it requests that IF D16 is blank AND either of D17,D22,D26 is blank THEN D15 should be blank, but the ELSE branch is not clear (perhaps in one case D15 should be the Lowest value of D17,D22,D26, and in another case D15 should be equal to D16, but there is no criterium given to differentiate these cases). Give an example! Regards, Stefi " ezt írta: 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help with an formula
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help with an formula
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help with an formula
=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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help with an formula
Hi Bob,
The code doesn't seem to work. The results display blanks. Stefi wrote: 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 |
|
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Help with an formula
Maybe you just wanted
=IF(OR(D16="",COUNTA(D17,D22,D26)=3),"",MIN(D17,D2 2,D26)) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) wrote in message ps.com... using my old code with IF(OR(D16="",COUNTBLANK(D17)+(D22)+D26)0) isn't valid as a function code. Is there anyway to resolved this issue. Cheers, Ims wrote: Hi Bob, The code doesn't seem to work. The results display blanks. Stefi wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | |||
Hybrid Mode
