Tuesday, April 9, 2013

How to Round in Excel

Question

I'm having trouble with rounding numbers in significant figures.
I was trying to round to 2 significant figures maintaining the equations I used, but I could not find way to do that.
Can I just get the numbers and round it myself?
But this way I wouldn't be able to show how I got the answers.

 

Answer

Excel help is pretty good on this.  On the PC the first answer when I searched (F1) for “rounding” the first article that appeared has extensive help on how to achieve multiple types of rounding.  that same article is available in this link.

No comments:

Post a Comment