< of two cells result

  • Thread starter Thread starter Peeps
  • Start date Start date
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:
 
Tue, 20 Jul 2004 08:05:51 -0500, Peeps wrote :
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...

=IF(C6<=H6;C6;IF(H6<C6;H6;""))
 
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.
 
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.
 
Back
Top