View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
bgarey bgarey is offline
external usenet poster
 
Posts: 6
Default significant figures?

When adding measurements, the final answer needs to be rounded off to the
least significant place value of the measurements:

The answer to 12.3 + 312.56 should be rounded off to the .10's place.
The answer to 1200 + 346 should be rounded off to the 100's place.

When multiply and dividing, the final answer should be rounded off to the
least number of significant digits.

The answer to 245 x 1.2 should be rounded to 2 digits and adding zero's for
place value if necessasry.


"Rick Rothstein" wrote:

I am not finding your question to be clear.. can you provide a little more
detail as to what you are looking for along with 3 or 4 examples of what you
have and what you expect them to look like after being rounded?

--
Rick (MVP - Excel)


"bgarey" wrote in message
...
Can I use excel to round operations with measurements to significant
figures