< of two cells result

P

Peeps

Ok, 2 year break from excel and the grey cell has gone on holiday!
I need to return a lesser than of two cells in cell g6

if c6 < h6, =c6, or if h6 < c6, = h6

tried several different ways, but to no avail, any help would b
greatly appreciated . /--- Paul:
 
N

Norman Harker

Hi Peeps!

You have a missing possibility. What if C6=H6?

MIN will return the value. But this may not be what you want. If that
is the case, then you'll need to use an IF function to return what you
want in this case.
 
A

Amedee Van Gasse

Peeps said:
Ok, 2 year break from excel and the grey cell has gone on holiday!
I need to return a lesser than of two cells in cell g6

if c6 < h6, =c6, or if h6 < c6, = h6

tried several different ways, but to no avail, any help would be
greatly appreciated . /--- Paul:)
Click to expand...


=MIN(C6,H6)

You're not restricted to 2 numbers. =MIN(A:A) is also valid (smallest
number in column A)

--
Amedee Van Gasse

To top-post is human, to bottom-post and snip is sublime.

Dit bericht is geplaatst in een nieuwsgroep. Post je evt antwoord of
vervolgvraag graag in dezelfde thread in de nieuwsgroep a.u.b.
 
Top