I have a column of currency amounts and I need to separate the sum of the dollar amount in one cell and the sum of the cents (everything after the decimal) in another cell. How do i write a formula to do this?
Thanks for any help you can give me!
Thanks for any help you can give me!