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
-
Xenny ·
Posted in New Builds and Planning1 -
kolly ·
Posted in Graphics Cards2 -
3
-
1
-
KazBoy1412 ·
Posted in General Discussion1 -
6
-
Fat Cat11997 ·
Posted in Graphics Cards5 -
1
-
Rahul Bansal ·
Posted in Laptops and Pre-Built Systems2 -
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