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
-
sweshy ·
Posted in New Builds and Planning0 -
0
-
DannyTechTips ·
Posted in Phones and Tablets4 -
TurkishBTW ·
Posted in Cases and Mods2 -
2
-
sweshy ·
Posted in New Builds and Planning0 -
AbrahamKH ·
Posted in CPUs, Motherboards, and Memory32 -
1
-
3
-
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