Help with an formula

[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(D1­7)+(D22)+(D26))))

Cheers

Ims

 

[Guest]

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

„[email protected]†ezt írta:

 

[ims121uk]

Yeah D15 should be the lowest value of D17, D22, D26. That Rights!

Thanks

Ims

 

[Robert McCurdy]

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

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

 

[ims121uk]

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

 

[Bob Phillips]

=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)

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

 

[Guest]

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:

 

[ims121uk]

Hi Bob,

The code doesn't seem to work. The results display blanks.

 

[ims121uk]

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

 

[Bob Phillips]

Maybe you just wanted

=IF(OR(D16="",COUNTA(D17,D22,D26)=3),"",MIN(D17,D22,D26))


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

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