formulas - using functions within tables in word 2010 -


i've created invoice within word, have table 2 columns following headings "description" "cost" @ bottom of table have 3 rows "subtotal" "vat" , "total" headings sit under description column , values these sit under cost column.

description           cost example 1             £ 5.00 example 2             £ 15.99   subtotal              £       vat                   £ total                 £ 

i have used following formula 'subtotal' cell

=sum(above) 

this works fine

i tried =b3/100*20 formula vat cell returned 0. did =above/100*20 worked rounded value up.

my issue how firstly stop rounding of numbers within formulas in word, , second issue cant 'total' work. word not =b3+b4 or did not this=sum(b3:b4)

any on appreciated. didn't realise creating invoice within word time consuming!

you can use round function , specify number of digits round to. in case should able calculate vat using following formula:

=round(sum(above)/100*20;4) 

a more detailed documentation available here:

use formula in word or outlook table


Comments