View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default Putting sums on your spreadsheet

hi,

if you want to add 14% vat is =a1*1.14
eg 100*1.14 = 114.00

to see the vat value =a1*1.14-a1

hth
regards from Brazil
Marcelo

"Little_Sam" escreveu:

How do i add a formula to my spread sheet

to put in an amount - add 14% vat then give a sub total of that