One way:

=MAX(A1:A5)

HTH,
Paul



--

"Anthony" wrote in message
...
Is there a formula if in diffrent cells I have a number and I want it to
return the highest number is that area. If anyone could please help.

Thanks