Excel help wanted

Discussion in 'Microsoft Certification' started by Richard Coulthard, Mar 5, 2004.

  1. A B C D
    1
    2 23 12
    3
    4

    I would like one cell to show the highest value only from
    the two cells above (e.g. figure shown)

    Can anyone HELP

    Richard Coulthard, Mar 5, 2004
    #1
    1. Advertising

  2. Richard Coulthard

    bpx Guest

    Use the MAX formula.
    Example: =MAX(B2:C2) Put this formula in the cell you
    want the result to show in.


    >-----Original Message-----
    > A B C D
    >1
    >2 23 12
    >3
    >4
    >
    >I would like one cell to show the highest value only

    from
    >the two cells above (e.g. figure shown)
    >
    >Can anyone HELP
    >
    >
    >.
    >
    bpx, Mar 6, 2004
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Tom
    Replies:
    1
    Views:
    526
    =?Utf-8?B?SWFu?=
    Dec 16, 2005
  2. Nnaemeka simeon.

    Excel help

    Nnaemeka simeon., Nov 5, 2004, in forum: Microsoft Certification
    Replies:
    1
    Views:
    548
    Cindy Winegarden
    Nov 6, 2004
  3. Robert
    Replies:
    5
    Views:
    1,143
    MELAD MARJI SR
    Jul 14, 2003
  4. mary wei

    - Need Help Rotating Text In Excel

    mary wei, Aug 6, 2003, in forum: Computer Support
    Replies:
    2
    Views:
    4,197
    rifleman
    Aug 7, 2003
  5. Brett
    Replies:
    0
    Views:
    1,045
    Brett
    Sep 9, 2004
Loading...

Share This Page