Rounding Formula
User251
✭✭✭✭
Hi,
I'd like to round the result of the division in this formula to the nearest whole number.
=IF([Column1]@row = "Text1", [Column2]@row, IF([Column2]@row = "n/a", "n/a", [Column2]@row / 2))
I tried placing MROUNDright before the last section of the formula like this, but I got the error "INCORRECT"
=IF([Column1]@row = "Text1", [Column2]@row, IF([Column2]@row = "n/a", "n/a", MROUND [Column2]@row / 2),2)
Can anyone suggest how the formula should be written?
Thanks.
Tags:
Best Answer

You need an opening parenthesis after the function.
MROUND([Column2]@row / 2),2)
Answers

You need an opening parenthesis after the function.
MROUND([Column2]@row / 2),2)

@Paul Newcome Thank you!

Happy to help. 👍️
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.1K Get Help
 349 Global Discussions
 199 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 133 Brandfolder
 127 Just for fun
 127 Community Job Board
 455 Show & Tell
 28 Member Spotlight
 1 SmartStories
 282 Events
 36 Webinars
 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!