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:
Comments
Post a Comment