Go Back   Velocity Reviews > Newsgroups > Microsoft Certification
User Name
Password
Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

Reply

Microsoft Certification - Excel help wanted

 
Thread Tools Search this Thread
Old 03-05-2004, 08:15 PM   #1
Default Excel help wanted


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
  Reply With Quote
Old 03-06-2004, 03:25 AM   #2
bpx
 
Posts: n/a
Default Excel help wanted

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
>
>
>.
>

  Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump