Tags: calculations, cell, excel, figure, formula, life, microsoft, msdn, numbers, pick, software

Formula to pick the lower of two cell calculations

On Microsoft » Microsoft Excel

2,118 words with 3 Comments; publish: Thu, 22 May 2008 06:47:00 GMT; (306125.00, « »)

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.

All Comments

Leave a comment...

  • 3 Comments
    • One way:

      =MIN(A1,B1)

      Another way:

      =IF(A1<B1,A1,B1)

      Hope this helps.

      Pete

      On Sep 19, 3:54 pm, dana.bush....excel.todaysummary.com.gmail.com 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.

      #1; Thu, 22 May 2008 06:49:00 GMT
    • =MIN(A1:B1)

      Regards,

      Peo Sjoblom

      <dana.bushman.excel.todaysummary.com.gmail.com> wrote in message

      news:1190213643.363109.319090.excel.todaysummary.com.k35g2000prh.googlegroups.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.

      >

      #2; Thu, 22 May 2008 06:50:00 GMT
    • 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

      <dana.bushman.excel.todaysummary.com.gmail.com> wrote in message

      news:1190213643.363109.319090.excel.todaysummary.com.k35g2000prh.googlegroups.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; Thu, 22 May 2008 06:51:00 GMT