Example 1
- 2, 5, 8, 11
0
What is the range of 2, 5, 8, 11? 0. a number read keeps 2, one number.
Range (max − min)
One text field. The formula wants a comma list, but the calculator calls a number read first. 2, 5, 8, 11 give 0. 1,9 give 0. 5 alone gives 0.
The field is text, the engine still runs a number read (comma to dot). One number remains, max − min of one element is 0.
Results
Enter data and click Calculate.
How it works
Range was meant to be max − min of a list. In the calculator formula the function splits a string on commas. the shared reader first turns commas into dots and calls a number read. From 2, 5, 8, 11 you get 2. From one number the range is 0.
That is why 2, 5, 8, 11 give 0. 1,9 becomes 1.9 and also 0. 5 alone gives 0. An empty field is a blank value, the function returns 0. The calculator does not show 9 from the list 2…11.
Dedicated min / max / range with three fields really computes the difference. There 1 and 9 give range 8. Here one field and a eaten list.
Maximum of two numbers returns the larger value, not a range. This calculator always falls to zero after a number read.
The header units switch does not multiply anything. 2, 5, 8, 11 stay 0 whatever the label says.
2, 5, 8, 11 give 0. 1,9 give 0. 5 alone gives 0.
Formula
intended: max − min of a comma list; actual: a number read, then range of one number = 0
How to use
- Type a list, for example 2, 5, 8, 11.
- Click Calculate. The range comes out 0, not 9.
- 1,9 also give 0. 5 alone gives 0.
- Generic a number read eats commas before the formula splits.
- A real range from a, b, c lives on the minimum and maximum card.
2, 5, 8, 11 give 0
Range after a number read is 0. 2, 5, 8, 11 give 0. 1,9 give 0. 5 alone gives 0.
- Range
- It was meant to be max − min of a list. After a number read it is 0. 2, 5, 8, 11 give 0.
- comma
- Generic turns it into a dot. 1,9 becomes 1.9. The list disappears.
- a number read
- The first step in the shared field reader. The split formula gets one number.
Examples
Example 2
- 1,9
0
What is the range of 1,9? 0. The comma becomes a dot, 1.9 remains.
Example 3
- 5
0
What is the range of 5 alone? 0. max − min of one element.
Related calculators
Common questions
What is the range of 2, 5, 8, 11?
0. Generic a number read takes 2. One number, range 0.
What does range max − min mean?
It was meant to be the list difference. The engine eats commas before a list appears sees a list.
What about 1,9?
0. 1,9 becomes 1.9. Still one number.
What about 5 alone?
0. max(5) − min(5) = 0.
Why not 9?
the shared field reader calls a number read after turning commas into dots. The formula gets a number, not a string.
What if the field is empty?
a blank value goes into the function, no numbers, result 0.
Do spaces save the list?
No. a number read still stops at the first number.
Where does range really work?
On the minimum and maximum of numbers card. Three fields and its own card.
Does the result always have six decimals?
0 is an integer, so the string 0. A fraction would get six decimal places, but here it is always 0.
Is the field text?
Yes. type=text. Generic still runs every value through a number read.
Knowledge sources
The engine reads one number; the range of a single value is 0. This is not a list max − min.
Page updated in 2026.