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!
-
Featured Topics
-
Topics
-
1
-
Aviaries ·
Posted in General Discussion2 -
OnTheRoccs ·
Posted in Graphics Cards4 -
zdemigod ·
Posted in Troubleshooting0 -
12
-
2
-
3
-
2
-
ave11 ·
Posted in Troubleshooting2 -
0
-
-
play_circle_filled
Latest From ShortCircuit:
Lian-Li, do this on all of your cases! - Lian-Li O11D x Lamborghini
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