Round function within a formula

Suzanne P
Suzanne P
edited 12/09/19 in Formulas and Functions


I am trying to round 2 numbers, multiply them and then take that sum and multiply it by another number.  In excel it is =round(A1,2)*round(A2,2)*A4.  I am having issues duplicating this in smartsheet. What am I doing wrong?  I have rounded down the columns, yet when doing the calculation with out the round function, it takes the extended value of the column, not the rounded number.

Thank you,




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!