Excel/Sheets Divide and Round Up
Go to solution
Solved by b_ondoptical,
So this is what I'm going with.
=ROUNDUP(G2/2)+0.99
Divides by 2, rounds up, and adds .99 so I get that wonderful psychological satisfaction of it being less than whatever big number is a penny away. Thanks everyone!
-
Topics
-
0
-
ian_one ·
Posted in Troubleshooting0 -
1
-
1
-
2
-
mx5nos ·
Posted in Troubleshooting2 -
2
-
pchelp ·
Posted in Programs, Apps and Websites4 -
Cople ·
Posted in New Builds and Planning3 -
2
-
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now