How to display a range

Question

How to do to display a range?If we have a value of for example 2,08 in a cell and want to display an acceptable range/variation, lets say +-1%. It can be displayed as [ =(2,08-2,08*1%)&amp;"_"&amp;(2,08+2,08*1%) ] which gives 2,05772_2,09878.How to do to limit the values to 2 decimals, i.e. 2,06_2,10?

bhushan_z · Answer

Use the ROUND function, which will help you round off your values

tiborm57 · Answer

bhushan_z&nbsp;How do i do that in the same cell?

bhushan_z · Answer

TiborM57&nbsp;here you go=ROUND((2,08-2,08*1%),2)&amp;"_"&amp;ROUND((2,08+2,08*1%),2)

tiborm57 · Answer

bhushan_z&nbsp;Sorry, can't make it to work, error is displayed, even when I copy your answer, is there something missing?

tiborm57 · Answer

TiborM57Excel doesn't recognize the values in the formula as numbers, why?

Forum Discussion

How to display a range

8 Replies

Resources