Rounding Significant Figures in Excel

Use the following formula to round a value to a certain number of sigfigs:



Vishal said...

How is this different from
I am trying to understand the need for using log and such, because I tried this for negative values and negative sigfigs.

The Chairman said...

Not sure if I can answer your question, but I would like to submit an alternative that I like to use.

I often use excel to generate values for my games, and I often want to round my cost formulas to only the first 2 sigfigs. (35,124,124 = 35,000,000 etc...)

so I use

the INT function only does anything if you have decimals which you don't want the LEN to read

the last +2 can be changed to round to a different number of first sig figs.