Sign in to join the conversation:
Hello, I want to be able to round up a number to the nearest whole - for example 4.1 would round to 5, 4 would stay as 4
5.6 would round to 6. any whole numbers would not round but stay the same.
I think that adding .49 (you may need to expand that however many decimals you might work with) to the number within the round formula will always round up.
I have heard of .5 but that would make an integer round up to the next one which won't do.
Round( x + .49)
So
4.5 rounds to 5
5 rounds to 5
5.01 rounds to 6
5.49 rounds to 6
Is that what you are looking for?
-Wilbs
Depending on the significant figures, 0.49 may not work (for example, 0.001 wil give incorrect answer)
This works for all significant digits.
=IF(Owner@row > INT(Owner@row), +1, 0) + INT(Owner@row)
If the numbers are negative and need to increase in magnitude (instead of rounding 'up'), that is a different problem, which I doubt applies here.
Craig
excellent thanks so much for your reply, this is great!
Has anyone done this? Can you add a form link (status update form) to a roll up sheet automatically once the project is provisioned in Control Center. Essentially the end goal is that already created template form, I would like the link to auto populate the form link from the status update sheet after provisioning so users…
I thought it would be easiest to create a reference sheet to house dates so I'm not constantly creating timeframe stipulators in my sheets, especially now that I am trying to create portfolio level rollups. When I observe the switch over from Mar to April, it seems like in order for the reference sheet to show April 1, I…
I'm looking for my source sheet for a form that is no longer active. I have the published link, but that is turning up as no longer published. My questions: Is it possible that the sheet was deleted? Is there a way for me to locate the source sheet? I thought I knew the title of the sheet, but when I search for it, it's…
