AndrewKonopacki

3 years agoQrew Member

# 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 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

------------------------------

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

------------------------------