Remember Me?

#1
September 19th 07, 03:54 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Sep 2007 Posts: 1
Formula to pick the lower of two cell calculations

There must be a simple way to do this, but I can't figure it out for
the life of me. I'm doing calculations and I have two numbers in two
different cells. Say, it's cell A1 and B1. I want cell C1 to simply
pick whichever number of those previous two is lower and display
that. How do I do that?

#2
September 19th 07, 03:57 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Aug 2006 Posts: 3,268
Formula to pick the lower of two cell calculations

=MIN(A1:B1)

--

Regards,

Peo Sjoblom

wrote in message
oups.com...
There must be a simple way to do this, but I can't figure it out for
the life of me. I'm doing calculations and I have two numbers in two
different cells. Say, it's cell A1 and B1. I want cell C1 to simply
pick whichever number of those previous two is lower and display
that. How do I do that?

#3
September 19th 07, 03:59 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 8,856
Formula to pick the lower of two cell calculations

One way:

=MIN(A1,B1)

Another way:

=IF(A1<B1,A1,B1)

Hope this helps.

Pete

On Sep 19, 3:54 pm, wrote:
There must be a simple way to do this, but I can't figure it out for
the life of me. I'm doing calculations and I have two numbers in two
different cells. Say, it's cell A1 and B1. I want cell C1 to simply
pick whichever number of those previous two is lower and display
that. How do I do that?

#4
September 19th 07, 04:04 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Feb 2007 Posts: 8,651
Formula to pick the lower of two cell calculations

Yes there is a simple way. The lower of the numbers in the minimum; the
function is MIN; Excel help will tell you the syntax and give examples.
--
David Biddulph

wrote in message
oups.com...
There must be a simple way to do this, but I can't figure it out for
the life of me. I'm doing calculations and I have two numbers in two
different cells. Say, it's cell A1 and B1. I want cell C1 to simply
pick whichever number of those previous two is lower and display
that. How do I do that?

 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 Rick A Excel Discussion (Misc queries) 1 August 31st 07 08:10 AM Barry Walker Excel Discussion (Misc queries) 0 August 14th 07 02:50 PM gautamghodadra@bellsouth.net Excel Worksheet Functions 6 December 22nd 06 03:39 AM g wills New Users to Excel 3 February 17th 05 10:23 PM proactive Excel Worksheet Functions 4 November 9th 04 05:00 AM

All times are GMT +1. The time now is 04:48 AM.