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!