ExcelBanter - Putting sums on your spreadsheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Putting sums on your spreadsheet (https://www.excelbanter.com/excel-worksheet-functions/97786-putting-sums-your-spreadsheet.html)

Little_Sam

Putting sums on your spreadsheet

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

Marcelo

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

All times are GMT +1. The time now is 10:40 PM.