Excel decision

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Reggie2004 - 24 Jun 2005 12:32 GMT

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

Reply to this Message

Anne Troy - 24 Jun 2005 13:08 GMT

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

www.OfficeArticles.com
www.MyExpertsOnline.com

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

Reply to this Message

JE McGimpsey - 24 Jun 2005 13:25 GMT

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.

Reply to this Message

Reggie2004 - 24 Jun 2005 14:29 GMT

Thanks for the help.

Signature

Reggie2004

Reply to this Message