significant figures
need to keep 4 significant figures at all times.
0.004454, 0.00004436, and 0.0004853.
What should those values be with 4 significant figures?
--
Biff
Microsoft Excel MVP
"Crystal" wrote in message
...
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
|