Results 1 to 3 of 3

Comparing cells and result enters the lower value

Threaded View

  1. #1
    Registered User
    Join Date
    08-31-2009
    Location
    Sarasota, FL
    MS-Off Ver
    Excel 2003
    Posts
    2

    Smile Comparing cells and result enters the lower value

    I have:
    Column A
    Column B
    Column C

    Column A and B have two different values or the same value.
    I would like Column C to compare Columns A to B.
    If Column A is the smaller cell enter that value in C
    If Column B is smaller cell enter that value in C
    If Column A and B are the same value, enter that value in C.

    What is the formula to be entered in C?

    V. Ouellette
    Last edited by kayone; 08-31-2009 at 07:01 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1