Reply
 
LinkBack Thread Tools Display Modes
  #1   Report Post  
Old September 19th 07, 03:54 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2007
Posts: 1
Default 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?

Thanks in advance.


  #2   Report Post  
Old 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
Default 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?

Thanks in advance.



  #3   Report Post  
Old 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
Default 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?

Thanks in advance.



  #4   Report Post  
Old 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
Default 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?

Thanks in advance.





Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula for Cell Calculations Rick A Excel Discussion (Misc queries) 1 August 31st 07 08:10 AM
Formula to pick out common parts of a cell and drop them in new sh Barry Walker Excel Discussion (Misc queries) 0 August 14th 07 02:50 PM
Automaticall pick up info from a cell from a shet t oanither sheet , in the same cell, same book [email protected] Excel Worksheet Functions 6 December 22nd 06 03:39 AM
Can you make a cell with a diagonal, so that you can edit the upper and lower part of the cell? g wills New Users to Excel 3 February 17th 05 10:23 PM
Can you enter a formula in a cell that auto-inputs calculations a. proactive Excel Worksheet Functions 4 November 9th 04 05:00 AM


All times are GMT +1. The time now is 11:59 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017