Hello,
I am trying to create a spreadsheet to add VAT to several cells in a row but only if a number is in the cell....
The number will only be in one cell of a row but could be any one and the VAT needs to be the end column. Anything in the 0 rated column should show zero in Vat column.

Column headings
Purchase Goods in goods out service rent 0 rated VAT
1526 228.9
5165 774.75
15663 2349.45
250 37.50
500 75.00
200 0.00

Hope this is clear enough ?

Thanks

Configuration: Windows XP Internet Explorer 8.0