Excel decision

[Reggie2004]

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

 

[Anne Troy]

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

www.OfficeArticles.com
www.MyExpertsOnline.com

 

[JE McGimpsey]

One way:

C1: =MIN(A1,B1)

copy down as far as required.

 

[Reggie2004]

Thanks for the help.