how to calculate range in excel?

Question

i i want to calculate range between upper and lower data what is th usefule
Execl function ?

Answer 1

=max(startcell:endcell)
=min(startcell:endcell)

You could display this as ="("&min(startcell:endcell)&","&max(startcell:endcell)&")"

Answer 2

assume your numbers are in a column using your example numbers a1=29 a2=47 and down the line until a10=100 then copy/paste this formula in an empty cell =SUM(MAX(A1:A10),-MIN(A1:A10)) then test it out if your numbers are in a row, then just change the range A1:A10 to your row range. you would use the Dvar or Dsum or other D formulas if your numbers are in a table os some sort.