Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
format cells number to 3 significant figures?? | Excel Discussion (Misc queries) | |||
significant figures? | Excel Discussion (Misc queries) | |||
Automatic formatting of Significant Figures .... | Excel Discussion (Misc queries) | |||
Rounding/Significant figures | Excel Worksheet Functions | |||
Significant figures (not decimal places) | Excel Worksheet Functions |