Remember Me?

#1
November 18th 04, 06:20 PM
 tbible Posts: n/a
Comparing 3 numbers and displaying the lesser of the three

I need to compare 3 numbers for example:

4

6

10

I need a formula that compares the three and puts the lesser of the 3 in a
different field or box.

Can someone help me?

#2
November 18th 04, 06:36 PM
 jtrevill Posts: n/a

Try

=MIN(M8:M10)

Where M8:M10 is the range of the data you are looking at...

--
jtrevill
------------------------------------------------------------------------
jtrevill's Profile: http://www.excelforum.com/member.php...o&userid=16601

#3
November 18th 04, 06:41 PM
 Arvi Laanemets Posts: n/a

Hi

=MIN(4,6,10)
or
=MIN(A1:A3)
with 3 values in range A1:A3,
or, when you search for minimal absolute value, then
=MIN(ABS(A1:A3))

Arvi Laanemets

"tbible" wrote in message
...
I need to compare 3 numbers for example:

4

6

10

I need a formula that compares the three and puts the lesser of the 3 in a
different field or box.

Can someone help me?

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post iart Excel Discussion (Misc queries) 15 September 10th 05 02:02 PM Joshua Wong Excel Discussion (Misc queries) 5 January 31st 05 04:50 PM SeeFar Excel Discussion (Misc queries) 2 December 28th 04 08:05 PM OldManP Excel Discussion (Misc queries) 3 December 8th 04 08:52 PM

All times are GMT +1. The time now is 07:31 PM.