Help with an formula

  • Thread starter Thread starter ims121uk
  • Start date Start date
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(D1­7)+(D22)+(D26))))

Cheers

Ims
 
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:
 
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
 
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
 
=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
 
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:
 
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
 
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
 
Back
Top