Forum Discussion

Qrew Member

3 years ago

Need some help, formula for calculating Significant Figures

I have a formula in excel that performs the task I need. When I build it in QuickBase I'm not getting the same results. I stripped it down to the basics, here are the two results. I need to return a v...

Formulas and functions

MarkShnier__You

Qrew Legend

3 years ago

Never knew what that meant in Excel.

Google says:
Can you round to significant figures in Excel?

For example, to round 2345678 down to 3 significant digits, you use the ROUNDDOWN function with the parameter -4, as follows: = ROUNDDOWN(2345678,-4). This rounds the number down to 2340000, with the "234" portion as the significant digits.

... When I get a chance I can respond, but it will take a formula as I doubt Quickbase supports that nuance of rounding to significant digits.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

AndrewKonopacki
Qrew Member
3 years ago
Thanks Mark. Yes, that is what I'm trying to accomplish in QB.

Here is another formula I used in Excel that returns what I want but doesn't return the same value in QuickBase.

=ROUND([value],[figure]-(1+INT(LOG10(ABS([value])))))

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