Make Interval Based On Smallest Number Joint With Hyphen Mark (-)

[muhammad susanto]

hi all...

how to make interval using smallest number & use hyphen mark
like layout table below :

			GIVEN NUMBER	2,9
NAME	VALUE	TARGET/EXPECTED RESULT
A	5,5	4-6,9	6,9
B	4
C	8,3
D	6
TARGET/EXPECTED RESULT
- SMALLEST NUMBER UNTILL (MARK "-") SMALLEST NUMBER+GIVEN NUMBER
6,9 NUMBER COME FROM 4 (SMALLEST NUMBER)+2,9 (GIVEN NUMBER )

<tbody>
</tbody>

any helps, thanks advance..
m.susanto

 

[Tetra201]

Try the following formula for displaying the interval:

=MIN($B$3:$B$6)&"-"&MIN($B$3:$B$6)+$E$1

 

[muhammad susanto]

Try the following formula for displaying the interval:

=MIN($B$3:$B$6)&"-"&MIN($B$3:$B$6)+$E$1

HI tetra201, working well....
thank you very much....