Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Computer Certification > Microsoft Certification > Excel help wanted

Reply
Thread Tools

Excel help wanted

 
 
Richard Coulthard
Guest
Posts: n/a
 
      03-05-2004
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

http://www.velocityreviews.com/forums/(E-Mail Removed)
 
Reply With Quote
 
 
 
 
bpx
Guest
Posts: n/a
 
      03-06-2004
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
>
>(E-Mail Removed)
>.
>

 
Reply With Quote
 
 
 
Reply

Thread Tools

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem with Excel reports ::::Excel 2003 Migration To Excel 2007 =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?= ASP .Net 15 10-24-2007 01:34 PM
Excel _WorkBook vs. Excel.Workbook =?Utf-8?B?SmltIEhlYXZleQ==?= ASP .Net 1 09-29-2004 03:48 PM
WANTED: AT desktop cases, wanted for sculpture. Brett NZ Computing 0 09-09-2004 07:14 AM
HELP WANTED HELP WANTED HELP WANTED Harvey ASP .Net 1 07-16-2004 01:12 PM
HELP WANTED HELP WANTED HELP WANTED Harvey ASP .Net 0 07-16-2004 10:00 AM



Advertisments