show the lowest value of two cells in a different cell

  • Thread starter Thread starter joe
  • Start date Start date
J

joe

hello, can anyone tell me how to show the lowest value of
two differnt cells in a seperate cell. example one cell
has a 5 in it and a different cell has a 4. i want a
different cell to show that the 4 is the lowest of the two
cells. i know this is probably easy but i'm a newbie and
can't figure it out yet. thanks for any help.
Joe
 
-----Original Message-----
hello, can anyone tell me how to show the lowest value of
two differnt cells in a seperate cell. example one cell
has a 5 in it and a different cell has a 4. i want a
different cell to show that the 4 is the lowest of the two
cells. i know this is probably easy but i'm a newbie and
can't figure it out yet. thanks for any help.
Joe
.
Click to expand...

Put the Formula "=Min(Cell Range)" Similarly for Large
Value "=Max(Cell Range).

Hope this will help you.

Sunil
 
Back
Top