Thread: Excel What Function shows value between highest and lowest number
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Joerg Mochikun Joerg Mochikun is offline
external usenet poster
  
Posts: 104
Default Excel What Function shows value between highest and lowest number
=MAX(A1:A10)-MIN(A1:A10)


"Mike R." <Mike wrote in message
...
I need to know the function that calculates the difference between the
highest number and teh lowest number in a set of numbers.


Reply With QuoteReply With Quote