=MAX(A1:A4)-MIN(A1:A4)

--
Kind regards,

Niek Otten

"Larry" <Larry@discussions.microsoft.com> wrote in message
news:02D4CA0F-49F9-4884-ACC0-2971855DC0A5@microsoft.com...
> With a set of four cells I want to find the the highest value and
> lowest
> valuve then find the difference between them.