Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for Cell Calculations | Excel Discussion (Misc queries) | |||
Formula to pick out common parts of a cell and drop them in new sh | Excel Discussion (Misc queries) | |||
Automaticall pick up info from a cell from a shet t oanither sheet , in the same cell, same book | Excel Worksheet Functions | |||
Can you make a cell with a diagonal, so that you can edit the upper and lower part of the cell? | New Users to Excel | |||
Can you enter a formula in a cell that auto-inputs calculations a. | Excel Worksheet Functions |