Merging fields to carry over figures

[markswan20]

Hi there please see attached if you need details of my problem.

I have an invoice i created but need to use seperate columns for pounds and pence. If the pence column is greater than £0.99 is there a way to ensure that the field displays just the pence but ammends another field with the additional value.

Many Thanks
Mark

[DonkeyOte]

Using your example file:

Z57: 
=SUMPRODUCT(--(0&Z27:Z54))+INT(SUMPRODUCT(--(0&AC27:AC54))/100)

AC57: 
=MOD(SUMPRODUCT(--(0&AC27:AC54)),100)

[markswan20]

Thanks for your very swift response,

That works a treat.

How would i calculate the same response in the VAT fields with the VAT @ 15%

Cheers Mark

[DonkeyOte]

perhaps

Z59: =INT(SUM($Z57,$AC57/100)*15%)

AC59: =100*MOD(SUM($Z57,$AC57/100)*15%,1)

[markswan20]

Fair play i had a go using the formula you provided in the first but failed miserably.

Final question what would i put to finish the sum in the total box below.

Prob should have said on the last post, sorry for being a pain.

Kindest Regards
Mark

[DonkeyOte]

If I've understood

Z61: =SUM(Z57,Z59,(AC57+AC59)/100)