Significant figures as a conditional format
 

I would like to be able to enter numbers in a cell and have the number of
significant figures automatically corrected defined by the following table

Number Report to nearest
0 -1.0 0.05
1 - 10 0.1
10 - 40 1
40 - 100 5
100 - 400 10

Significant figures as a conditional format
 

=ROUND(A9/LOOKUP(A9,{0,1,10,40,100},{0.05,0.1,1,5,10}),0)*LO OKUP(A9,{0,1,10,40,100},{0.05,0.1,1,5,10})

--
__________________________________
HTH

Bob

"stephenp" wrote in message
...
I would like to be able to enter numbers in a cell and have the number of
significant figures automatically corrected defined by the following table

Number Report to nearest
0 -1.0 0.05
1 - 10 0.1
10 - 40 1
40 - 100 5
100 - 400 10

Significant figures as a conditional format
 

Thanks. One issue. I would like the analyst to enter the value into say, cell
D40, and have that value adjusted and be dispalyed in cell D40. If I put the
formula in cell D40 it is a circular reference issue.

"Bob Phillips" wrote:

=ROUND(A9/LOOKUP(A9,{0,1,10,40,100},{0.05,0.1,1,5,10}),0)*LO OKUP(A9,{0,1,10,40,100},{0.05,0.1,1,5,10})

--
__________________________________
HTH

Bob

"stephenp" wrote in message
...
I would like to be able to enter numbers in a cell and have the number of
significant figures automatically corrected defined by the following table

Number Report to nearest
0 -1.0 0.05
1 - 10 0.1
10 - 40 1
40 - 100 5
100 - 400 10

Significant figures as a conditional format
 

That is right, you need 2 cells, you cannot have the input value and the
result in the same cell.

--
__________________________________
HTH

Bob

"stephenp" wrote in message
...
Thanks. One issue. I would like the analyst to enter the value into say,
cell
D40, and have that value adjusted and be dispalyed in cell D40. If I put
the
formula in cell D40 it is a circular reference issue.

"Bob Phillips" wrote:

=ROUND(A9/LOOKUP(A9,{0,1,10,40,100},{0.05,0.1,1,5,10}),0)*LO OKUP(A9,{0,1,10,40,100},{0.05,0.1,1,5,10})

--
__________________________________
HTH

Bob

"stephenp" wrote in message
...
I would like to be able to enter numbers in a cell and have the number
of
significant figures automatically corrected defined by the following
table

Number Report to nearest
0 -1.0 0.05
1 - 10 0.1
10 - 40 1
40 - 100 5
100 - 400 10