Simon Lloyd
05-10-2008, 12:31 PM
Hi all, a friend of mine has designed a sheet for his daughters business, it shows cheques/money taken then the amount of vat that is a portion of the cheque/money taken and he wants a value shown which is the cheque/money less VAT....i know what your thinking....dead easy, yep will so did i until he sent me the format he wants it in. He wants to enter the ?'s in one column and the pence in another for the cheques/money and the same for the VAT they are charging,the less VAT columns will have the same format.
The problem is how to deduct the pence from the pounds? the layout and result is as follows e.g please read this as columns
A,...B,...C,....D,...E,..F
?22 23p ?12 99p ?9 24p
Please see attached!
The problem is how to deduct the pence from the pounds? the layout and result is as follows e.g please read this as columns
A,...B,...C,....D,...E,..F
?22 23p ?12 99p ?9 24p
Please see attached!