Formula for adding dollars and cents when split across two cells

Hi all,

I am new to the forum and unsure if this topic has already been posted. I have browsed through and found mention of trying to split a single dollar amount into two columns but not to add them while keeping split. see below

I have a petty cash document which lists dollars and cents in two separate columns and total's them at the bottom with the dollars and cents still split across two columns.

My problem is when adding the cents I can't figure out how to split the dollars from the cents and add to the dollars coloum while deducting the dollars from the cents column.

Ex.

A=Dollars B=Cents

A1=23, B1=35
A2=34, B2=89
A3=total dollars (inc cents that add to a dollar), B3=total cents

So in this example i would be adding $23.35 + $34.89 = $58.24
In this example the cents add up to an additional dollar.

Help anyone?

Thanks!

Thats it!! Thank you very much ben_hensel!!

Thanks AlKey!

But i want to keep the bottom 3 row separate. so A3=58 and B3=24
Thoughts?

Is the INT and MOD solution better than the TRUNC solution ben_hensel gave? What would be the difference?

Thanks AlKey!