eXCEL fUNCTIONS
 

How do I get Excel to figure out the lesser of two cells. For example I want
to write a function that says C3 equals the lesser of A3 and B3. Someone
please help.

eXCEL fUNCTIONS
 

hi,
try this....
=IF(A1B1,A1,B1)


regards
FSt1

"Herb" wrote:

How do I get Excel to figure out the lesser of two cells. For example I want
to write a function that says C3 equals the lesser of A3 and B3. Someone
please help.

eXCEL fUNCTIONS
 

Put this in C3:

=MIN(A3,B3)

Also, see your other (not quite duplicate) post.

Hope this helps.

Pete

On Feb 4, 1:42*am, Herb wrote:
How do I get Excel to figure out the lesser of two cells. *For example I want
to write a function that says C3 equals the lesser of A3 and B3. *Someone
please help.