ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   range function (https://www.excelbanter.com/excel-discussion-misc-queries/128149-range-function.html)

Felicia

range function
 
How do I calculate the range of numbers in one cell in excel?

Dave F

range function
 
I'm not sure I understand your question. "range" generally refers to
multiple cells in Excel.

Perhaps you mean the difference between two numbers? Then just do =A1-B1

Dave
--
Brevity is the soul of wit.


"Felicia" wrote:

How do I calculate the range of numbers in one cell in excel?


Max

range function
 
Perhaps you mean something like this, in say B1:
=MAX(A1:A10)-MIN(A1:A10)

assuming the source range of numbers is within A1:A10
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Felicia" wrote:
How do I calculate the range of numbers in one cell in excel?



All times are GMT +1. The time now is 02:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com