I have 14 collums in use 1 of which is for VAT and the other for the
total
10 collums do have vat and 2 don't. I would like to know if there is a
forumula I can use:
Col A ColB ColC ColD ColE Colf ColG GolH GolI Col J
vat Col total
vat inc nil v vatinc nil vatin vat nil vat vat
vat 17.5%

5.00 1.00 5.55
5.00 1.49 16.55

my question is what formula do I use in the total col? thank you


--
chrissy
------------------------------------------------------------------------
chrissy's Profile: http://www.excelforum.com/member.php...o&userid=15847
View this thread: http://www.excelforum.com/showthread...hreadid=274948