View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SnowyHJT SnowyHJT is offline
external usenet poster
 
Posts: 3
Default Amount minus VAT

Thank you Jacob, a great help
--
Snowyhjt


"Jacob Skaria" wrote:

=A1-(A1*0.15)

If this post helps click Yes
---------------
Jacob Skaria


"SnowyHJT" wrote:

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.
--
Snowyhjt