Amount minus VAT

[SnowyHJT]

If I enter an amount in A1 (£57.50) how can I show the Total less 15% VAT.
I need to enter different amounts in A1, A2 etc. all way down the A Column
and show in the B Column Less 15% VAT.

Any help would be much apreciated.

 

[Jacob Skaria]

=A1-(A1*0.15)

If this post helps click Yes

 

[Mike H]

Hi,

Try

=(A1/115)*100

Mike

 

[Jacob Skaria]

Ooops...You are right...Thanks Mike...

Let me go and sleep...

If this post helps click Yes

 

[SnowyHJT]

Thank you Jacob, a great help
--
Snowyhjt

=A1-(A1*0.15)

If this post helps click Yes

 

[SnowyHJT]

Thank you Mike, it worked great
--
Snowyhjt

Hi,

Try

=(A1/115)*100

Mike

 

[Jacob Skaria]

Sorry. Use the formula in Mike's post...=(A1/115)*100


If this post helps click Yes