Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

determining highest and lowest in a range of cells 1

Status
Not open for further replies.
LindaEPI

LindaEPI

Technical User
Jul 16, 2002
37
US
How do I create a formula for a row of cells that have different prices in them to determine the lowest and highest value?
 
Sort by date Sort by votes
MIN() and MAX() functions:

=MIN(A1:H1)

=MAX(A1:H1)

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...
 
Upvote 0 Downvote
Thank you so much, it worked!
such a simple formula...DUH
"you don't know what you don't know"

Thanks again!!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

N1GHTEYES
  • Locked
  • Question
Count range overlap cells
Replies
3
Views
254
N1GHTEYES
N1GHTEYES
N1GHTEYES
  • Locked
  • Question
Count areas within a range 1
Replies
14
Views
726
SkipVought
S
scubafrog79
  • Locked
  • Question
Formula for checking cells for value and then subtract value 1
Replies
8
Views
216
SkipVought
S
PSchubert
  • Locked
  • Question
Excel - SUMIFS() works with one range, but doesn't with another nearly identical range 2
Replies
6
Views
186
Andrzejek
Andrzejek
R
  • Question
Issues with Outlook default account and performance
Replies
0
Views
179
radleymartinez
R

Part and Inventory Search

Sponsor

Back
Top