Hi

For highest =MAX(A1:A100
For lowest =MIN(A1:A100)

Substitute your range for A1:A100

Regards

Roger Govier


SAINTJOHN wrote:
I need to calculate a formulae within a given range so it gives me the
highest number and lowest number

Thanks in anticipation

John