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))
=IF((H28<H29)^(H28<H30),H28,IF(H29<H30,H29,H30))





RE: Determining the Minimum of Three Numbers
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
=====================================
Eng-tips forums: The best place on the web for engineering discussions.
RE: Determining the Minimum of Three Numbers
TTFN
RE: Determining the Minimum of Three Numbers
THANKS
RE: Determining the Minimum of Three Numbers
=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
=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
Hg
Eng-Tips policies: FAQ731-376
RE: Determining the Minimum of Three Numbers
"^" 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
gman1