×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Determining the Minimum of Three Numbers

Determining the Minimum of Three Numbers

Determining the Minimum of Three Numbers

(OP)
I have three numbers in cells H28, H29 and H30.  I am trying to find the minimum of those three numbers.  I tried doing the formula below but it does not seem to work.  After talking to a co-worker he brought up the MIN function.  That also works, but I guess right now I am trying to figuere out why the function below is not working.  Appreciate if your help.  THANKS.

=IF((H28<H29)^(H28<H30),H28,IF(H29<H30,H29,H30))

RE: Determining the Minimum of Three Numbers

I'm not sure what you're trying to do with ^

The following will work to give the min of the three cells (assuming none are equal and you don't want to use min)
=+IF(H28<H29,IF(H28<H30,H28,H30),IF(H29<H30,H29,H30))

=====================================
Eng-tips forums: The best place on the web for engineering discussions.

RE: Determining the Minimum of Three Numbers

One possible result of your test is 0^0.  That is somewhat undefined. There was a discussion in the mechanical engineering other topics forum.

=====================================
Eng-tips forums: The best place on the web for engineering discussions.

RE: Determining the Minimum of Three Numbers

You should NEVER use Booleans in arithmetic expressions.

TTFN



RE: Determining the Minimum of Three Numbers

(OP)
I was trying to use the AND statement by using ^.  I have used this in mathcad, but I guess it does not work in excel, or is there another way I can use AND statement within and IF statement?

THANKS

RE: Determining the Minimum of Three Numbers

The more structured way would be
=IF(AND((H28<H29),(H28<H30)),H28,IF(H29<H30,H29,H30))

Under peril of incurring uppercase wrath of other posters, I will mention (but not recommend) that you can also use "*" to accomplish boolena "and":
=IF(AND((H28<H29)*(H28<H30)),H28,IF(H29<H30,H29,H30))

=====================================
Eng-tips forums: The best place on the web for engineering discussions.

RE: Determining the Minimum of Three Numbers

Whoops. My last example had a * and an "and". I meant:
=IF((H28<H29)*(H28<H30),H28,IF(H29<H30,H29,H30))

=====================================
Eng-tips forums: The best place on the web for engineering discussions.

RE: Determining the Minimum of Three Numbers

"^" in Excel is an exponent, not an "and".

Hg

Eng-Tips policies:  FAQ731-376

RE: Determining the Minimum of Three Numbers

gman1, HgTX got it right.

"^" is an exponent (raised to the power of).

"Do not worry about your problems with mathematics, I assure you mine are far greater."   
Albert Einstein
Have you read FAQ731-376 to make the best use of Eng-Tips Forums?

RE: Determining the Minimum of Three Numbers

(OP)
THANKS, you guys have been very helpfull.

gman1

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources