Format cCell to find greatest value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreadsheet that I am working with and I am stumped on a formula
that I wish to create.

I have three columns (A, B & C) that have multiple rows of data that vary
based on what is entered for that day. I wish to have column D automatically
fill with the data that is the greatest value out of the three previous cells.
See below - I want cell D to automatically "grab" the 98, 105, and so on;

A B C D
51 45 98 *
38 105 73 *
....
....


Thanks for your help!!!
 
Try something like this:

D1: =MAX(A1:C1)

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 

Ask a Question

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

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top