Forum Discussion

Qrew Cadet

Re: Need some help, formula for calculating Significant Figures

HI Andrew;
If I understood correctly you want to round to 10's.
You can try,

Round([Number], 10)

Round(26.6, 10) ==> returns 30

I hope this helps :)

------------------------------
Razi D.
Desta Tech LLC
razi@destatechs.com
------------------------------

1 Reply

AndrewKonopacki
Qrew Member
3 years ago
Correct. I came to the same conclusion last night after giving it some more thought. 95% of my values will be less than 10k, but would still need to be able to stay within my 2 sig fig parameter if the number got to 100k or more. This works fine for my application. Thanks again for both of your inputs!

If([M1 - Spores m3]<100, Round([M1 - Spores m3],1),
[M1 - Spores m3]<999, Round([M1 - Spores m3],10),
[M1 - Spores m3]<9999, Round([M1 - Spores m3],100),
[M1 - Spores m3]<99999, Round([M1 - Spores m3],1000),
[M1 - Spores m3]>99999, Round([M1 - Spores m3],10000))

------------------------------
Andrew Konopacki
------------------------------