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
-
0
-
0
-
prize of script ·
Posted in Troubleshooting2 -
Grimbo ·
Posted in General Discussion1 -
2
-
0
-
NickKz ·
Posted in Home Theater Equipment0 -
2
-
0
-
Sall93 ·
Posted in Troubleshooting1
-
-
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