Calculate a Formulae

[SAINTJOHN]

I need to calculate a formulae within a given range so it gives me th
highest number and lowest number

Thanks in anticipation

Joh

 

[Ron Coderre]

Have you tried something like these?:

=MAX(A1:A10)

=MIN(A1:A10)

Does that help?

Regards,
Ro

 

[Roger Govier]

Hi

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

Substitute your range for A1:A100

Regards

Roger Govier

 

[SAINTJOHN]

Thanks for that, much appreciate