K0st4din
Active Member
- Joined
- Feb 8, 2012
- Messages
- 488
- Office Version
- 2016
- 2013
- 2011
- 2010
- 2007
- Platform
- Windows
Hello, everyone,
I'm trying to find a solution for a formula that, after summing a certain column of numbers, can round the sum to the larger round number.
For example:
The column is A2:A6
a2 = 5.20
a3 = 0.80
a4 = 100.00
a5 = 55.00
a6 = 20.02
total is = 181.02
I'm looking in this example to be able to round to be = 200.00
That is, to be a round number, but the largest
Thanks to anyone who could help me
I'm trying to find a solution for a formula that, after summing a certain column of numbers, can round the sum to the larger round number.
For example:
The column is A2:A6
a2 = 5.20
a3 = 0.80
a4 = 100.00
a5 = 55.00
a6 = 20.02
total is = 181.02
I'm looking in this example to be able to round to be = 200.00
That is, to be a round number, but the largest
Thanks to anyone who could help me