Hi Geoff,

Excel will multiply a zero rate.
What happens in your case? What's your formula?

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Geoff" wrote in message
...
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