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.
|