Formula for highest/lowest cost

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

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

--
Kind regards,

Niek Otten

"S S" <yamxsnonsense@blueyonder.co.uk> wrote in message news:Q_H4g.176129$8Q3.89313@fe1.news.blueyonder.co.uk...
|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
|
|
|

Thanks Niek


"Niek Otten" <nicolaus@xs4all.nl> wrote in message
news:%231auqB4aGHA.1192@TK2MSFTNGP03.phx.gbl...
> =MAX(A3:A20)
> =MIN(A3:A20)
>
> --
> Kind regards,
>
> Niek Otten
>
> "S S" <yamxsnonsense@blueyonder.co.uk> wrote in message
> news:Q_H4g.176129$8Q3.89313@fe1.news.blueyonder.co.uk...
> |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
> |
> |
> |
>
>