Forum Discussion

Copper Contributor

May 27, 2020

How to display a range

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%)&"_"&(2,08+2,...

developer

excel

Formulas and Functions

bhushan_z

Iron Contributor

May 27, 2020

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

TiborM57
Copper Contributor
May 27, 2020
bhushan_z
How do i do that in the same cell?
- bhushan_z
  Iron Contributor
  May 27, 2020
  TiborM57 here you go
  =ROUND((2,08-2,08*1%),2)&"_"&ROUND((2,08+2,08*1%),2)
  - bhushan_z
    Iron Contributor
    May 27, 2020
    must be formatting thing, try '"." instead.
    Use this:
    
    =ROUND((2.08-2.08*1%),2)&"_"&ROUND((2.08+2.08*1%),2)