Decimal place conditional formatting for number value based on another cell value.

[babaso_tawase]

Dear all,

I have excel 2007 data

I used formula as ` =round (data1+data2,rounding digit).

Rounding digit

2

Column1	Column2	Column3
DATA1	DATA2	RESULT
1.02	1.05	2.07
1.05	1.05	2.1
1.9	1.1	3

I want result as below

Column1	Column2	Column3
DATA1	DATA2	RESULT
1.02	1.05	2.07
1.05	1.05	2.10
1.9	1.1	3.00

I want display result in result column 3.. as per rounding digit decided, but excel shows less digit if decimal is zero. Result column should not exclude zero. decimal should as per rounding digit regardless decimal value zero or other number.

 

[Sergius]

Hello! For cells in the third column, use the Number cell format with two decimal places.

 

[babaso_tawase]

Hello! For cells in the third column, use the Number cell format with two decimal places.

Thanks for reply...but rounding digit cell is unlocked cell ..user can only enter data1 and data2...all other cells are locked...rounding digit may vary like 1, 2,3,4 etc...I am searching for this and other than Text function..

 

[Sergius]

But in the first post you write

I used formula as ` =round (data1+data2,rounding digit)

Now say the column is locked.
If you design this table, you can make changes at the design stage. Or did I misunderstand something?

 

[babaso_tawase]

Only result column last is locked...first two columns and rounding digit cell is unlocked...
User can decide rounding digit.
Working above formula perfect but omitting zeros after decimal if present