Nov 18 2020 12:37 PM - edited Nov 18 2020 12:47 PM
Nov 18 2020 01:14 PM
Nov 18 2020 01:24 PM
Hi there,
To be honest, I don't understand your query. However, I tried to solve this issue as I understood using Round Function.
And it worked well.
Please note attached file.
If you can clarify your question a little bit more, I can help you.
Nov 18 2020 02:10 PM
@Norman_Glenn The function CEILING() or CEILING.MATH() is what you want, but you also mention that negative number you want to be 0 so you can use MAX(CEILING(A1,1),0) so either A1 is rounded up to the next integer if positive or it is set to 0 if negative.
Nov 19 2020 12:26 PM
Nov 19 2020 12:30 PM
Nov 19 2020 01:04 PM
Nov 19 2020 01:22 PM
Glad to hear it, a shortcut to adjust decimal placements is available in the Home ribbon.