Skip to main content
Question

Need some help, formula for calculating Significant Figures

  • April 26, 2022
  • 0 replies
  • 113 views
Forum|alt.badge.img+1
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 value that is a significant figure of 2.

Excel (the way I want it to work)
Returns 30
=ROUND(26.6,-1)

QuickBase 
Returns 27
=ROUND(26.6,-1)

Any help would be greatly appreciated.

------------------------------
Andrew Konopacki
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
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
------------------------------
Mark Shnier. Your Quickbase Coach
RaziD
Forum|alt.badge.img+3
  • RaziD
  • Registered
  • April 27, 2022

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
------------------------------
Razi D. [WebsiteUrl]
Terms & ConditionsAccessibility statement