excel 2003 training - Excel

Hi Kevin

Thank you for your question.

I think this is best answered with a specific example. We will create a function called VatPre which will take any price that includes VAT and work out the non VAT element of that. Go to the VBE by pressing ALT-F11 and create a new module. In the code window type the following

private function VatPre(VAT as single) as single



   vatPre = VAT/1.175



end function

The line "private function VatPre(VAT as single) as single" defines the function as having one argument "VAT" which will be the amount including VAT.

The line "VatPre = VAT/1.175" simply sets the value of the function equal to VAT divided by 1.175.

I hope this helps. If you have any further questions please do not hesitate to ask

Regards

Stephen