Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
significant figures
Here is my dilema: Have a huge spread sheet that takes hours of manual
calculations and turns it into a 5-10min process. However i am in the process of validating it but in my eyes its not good enough. In my spreadsheet i need to keep 4 significant figures in most of my showing calc's but the input values change. So for instance, I get .004454, 0.00004436, and 0.0004853. I need to keep 4 significant figures at all times. But i cannot use the round function the way that excel help has it definded. i can only get it to keep "X" amount of digets which is not what i want. Is there anything i can do to change this or is it asking to much of excel? Thanks, Crystal |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Significant figures as a conditional format | Excel Worksheet Functions | |||
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 |