VAT and blank cells

[AdRock]

I am trying to create an invoice for college.

The problem I'm having is adding VAT on a sub total + delivery.

I have tried different sums to try and calculate sub total, deliver
and VAT but nothing works.

I want to display the total cost including delivery and VAT and i
nothing is entered in the invoice then nothing is displayed in th
sums.

Does anyone know how to do this as this is quite urgent?

AdRoc

 

[Norman Harker]

Hi Adrock!

I'll assume that cost is in A3 with a delivery percent in A2 and a VAT
percent in A1.

B3 formula would be:

=IF(A3="","",A3*(1+$A$2)*(1+$A$1))

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)

It is imperative that the patches provided by Microsoft in its April
Security Release be applied to Systems as soon as possible. Worms /
viruses that exploit vulnerabilities addressed by these patches are
now spreading.
See:
http://www.microsoft.com/security/protect/