Please can anyone tell me what formula to use to calculate how much 17.5% of
a figure is.
I have 3 columns - Net Amount, VAT, Gross Amount. I need it to calculate
the VAT of the Net Amount & then add the Net Amount & VAT together to give me
the Gross Amount.
It's driving me nuts as I don't know the formulas to make it do that, please
can anyone help.

--
No one said that life would be a party ... but while we''re here, we might
as well dance.

Jen xx

Hi,

I think this is what you mean

A B C
Net Vat Gross
100 17.5 117.5

Net value =100
VAT formula =A1*0.175
Gross formula = A1+B1

Mike
"Foxylady" wrote:

Please can anyone tell me what formula to use to calculate how much 17.5% of
a figure is.
I have 3 columns - Net Amount, VAT, Gross Amount. I need it to calculate
the VAT of the Net Amount & then add the Net Amount & VAT together to give me
the Gross Amount.
It's driving me nuts as I don't know the formulas to make it do that, please
can anyone help.

--
No one said that life would be a party ... but while we''re here, we might
as well dance.

Jen xx

Thank you sooooo much Mike, you're a star! :)
--
No one said that life would be a party ... but while we''''''''re here, we
might as well dance.

Jen xx


"Mike H" wrote:

Hi,

I think this is what you mean

A B C
Net Vat Gross
100 17.5 117.5

Net value =100
VAT formula =A1*0.175
Gross formula = A1+B1

Mike
"Foxylady" wrote:

Please can anyone tell me what formula to use to calculate how much 17.5% of
a figure is.
I have 3 columns - Net Amount, VAT, Gross Amount. I need it to calculate
the VAT of the Net Amount & then add the Net Amount & VAT together to give me
the Gross Amount.
It's driving me nuts as I don't know the formulas to make it do that, please
can anyone help.

--
No one said that life would be a party ... but while we''re here, we might
as well dance.

Jen xx