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.