Use the following formula to round a value to a certain number of sigfigs:
=ROUND(value,sigfigs-(1+INT(LOG10(ABS(value)))))
2 comments:
Anonymous
said...
How is this different from =ROUND(value,sigfigs-1) I am trying to understand the need for using log and such, because I tried this for negative values and negative sigfigs.
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 =ROUND(value,LEN(INT(value))*-1+2)
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.
2 comments:
How is this different from
=ROUND(value,sigfigs-1)
I am trying to understand the need for using log and such, because I tried this for negative values and negative sigfigs.
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
=ROUND(value,LEN(INT(value))*-1+2)
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.
Post a Comment