+ Reply to Thread
Results 1 to 3 of 3

Need a formula to determine the greater of a or b...

  1. #1
    sonyav
    Guest

    Need a formula to determine the greater of a or b...

    I need to compare 2 number and enter into a 3rd column the greater of the 2
    numbers.

  2. #2
    Paul B
    Guest

    Re: Need a formula to determine the greater of a or b...

    sonyav, how about something like this =MAX(A1:B1)
    --
    Paul B
    Always backup your data before trying something new
    Please post any response to the newsgroups so others can benefit from it
    Feedback on answers is always appreciated!
    Using Excel 2002 & 2003

    "sonyav" <sonyav@discussions.microsoft.com> wrote in message
    news:2C3ADF16-8CB9-4D46-8A3B-6F4EB27A97AB@microsoft.com...
    >I need to compare 2 number and enter into a 3rd column the greater of the 2
    > numbers.




  3. #3
    ww
    Guest

    RE: Need a formula to determine the greater of a or b...

    If you're comparing numbers from column A to a number in column B
    just enter =IF(A1>B1,A1,B1) in Column C

    "sonyav" wrote:

    > I need to compare 2 number and enter into a 3rd column the greater of the 2
    > numbers.


+ Reply to Thread

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