Formula for highest/lowest cost

S

S S

I have a column A with rows 3 to 20 which has prices in the cells
I want to put in say B1 the highest price from A 3 : 20
and to put in say B2 the lowest price from A 3 : 20

Can someone help me with a formula
thanks
 
N

Niek Otten

=MAX(A3:A20)
=MIN(A3:A20)

--
Kind regards,

Niek Otten

|I have a column A with rows 3 to 20 which has prices in the cells
| I want to put in say B1 the highest price from A 3 : 20
| and to put in say B2 the lowest price from A 3 : 20
|
| Can someone help me with a formula
| thanks
|
|
|
 

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

Similar Threads

Delete duplicate cells in a row based on the best price in anothercell from another row 1
Conditional format question 4
VBA 0
Ranking, I think 3
Lowest number excluding zero 2
If question 3
PowerPoint Powerpoint image ordering on a single slide 3
Finding cell text corresponding to the MAXimum figure in a spreadsheet? 1

Top