Help with an formula

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
 
S

Stefi

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:
 
R

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
 
I

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
 
B

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
 
I

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
 
B

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top