Wanting to sum a colum of numbers and then roundup to the next dol
 

I'am wanting to write a formula that would sum a colum of numbers and then
round those numbers up or down to the hole dollar.
A B
1 22.10 45.76
2 22.35 43.10
3

I would want cell A3 to roundup to 45.00 and cell B3 to rounddown to 48.00.

Thanks for any help.

Wanting to sum a colum of numbers and then roundup to the next dol
 

In A3 for your example:
=CEILING(SUM(A1:A2),1)
In B3:
=FLOOR(SUM(B1:B2),1)

"AL" wrote:

I'am wanting to write a formula that would sum a colum of numbers and then
round those numbers up or down to the hole dollar.
A B
1 22.10 45.76
2 22.35 43.10
3

I would want cell A3 to roundup to 45.00 and cell B3 to rounddown to 48.00.

Thanks for any help.

Wanting to sum a colum of numbers and then roundup to the next
 

Thanks BoniM! That's what I was looking for.
AL

"BoniM" wrote:

In A3 for your example:
=CEILING(SUM(A1:A2),1)
In B3:
=FLOOR(SUM(B1:B2),1)

"AL" wrote:

I'am wanting to write a formula that would sum a colum of numbers and then
round those numbers up or down to the hole dollar.
A B
1 22.10 45.76
2 22.35 43.10
3

I would want cell A3 to roundup to 45.00 and cell B3 to rounddown to 48.00.

Thanks for any help.

Wanting to sum a colum of numbers and then roundup to the next
 

You're welcome, happy to help. Thanks for the feedback!

"AL" wrote:

Thanks BoniM! That's what I was looking for.
AL

"BoniM" wrote:

In A3 for your example:
=CEILING(SUM(A1:A2),1)
In B3:
=FLOOR(SUM(B1:B2),1)

"AL" wrote:

I'am wanting to write a formula that would sum a colum of numbers and then
round those numbers up or down to the hole dollar.
A B
1 22.10 45.76
2 22.35 43.10
3

I would want cell A3 to roundup to 45.00 and cell B3 to rounddown to 48.00.

Thanks for any help.