Calculating High and Low

[Cindy]

I am working on a spreadsheet that has ANNUAL HIGH and ANNUAL LOW columns for
an energy audit. I need to calculate across the cell which is the high and
low for each customer. Is there a particular formula that I use to get these?

 

[Luke M]

use MAX and MIN

e.g.,
=MAX(A2:A100)
would return the highest number in that range.

 

[Cindy]

Luke- Thank you. I found something in an earlier post just as I was getting
your reply.