Round function within a formula
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.
Help Article Resources
Check out the Formula Handbook template!