Excel decision

I have a spreadsheet. I need to compare 2 columns and have the smaller of the 2 show in a third column.

=if(a2>b2,a2,b2)
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Reggie2004" <Reggie2004.1r4qmo_1119614720.0962@excelforum-nospam.com> wrote
in message news:Reggie2004.1r4qmo_1119614720.0962@excelforum-nospam.com...
>
> I have a spreadsheet. I need to compare 2 columns and have the smaller
> of the 2 show in a third column.
>
>
> --
> Reggie2004
> ------------------------------------------------------------------------
> Reggie2004's Profile:
http://www.excelforum.com/member.php...o&userid=15085
> View this thread: http://www.excelforum.com/showthread...hreadid=381911
>

One way:

C1: =MIN(A1,B1)

copy down as far as required.


In article <Reggie2004.1r4qmo_1119614720.0962@excelforum-nospam.com>,
Reggie2004 <Reggie2004.1r4qmo_1119614720.0962@excelforum-nospam.com>
wrote:

>
> I have a spreadsheet. I need to compare 2 columns and have the smaller
> of the 2 show in a third column.

Thanks for the help.