Hi

I want to create a formula where if for example I have £100 in a column, the
next column to put the vat rate 1.175 and the next column to sum both these
figures giving the answer of £117.50.
The above I can do without any problems. The help I need is if the vat rate
is zero.
What formula do I use so that the figure put into the vat rate column
whether it be 1.175 or 0.00 excel will calculate. Excel will not multiply a
zero rate
Hope this makes sense
Thanks in advance