| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How to add a subract field in a word
Hi guys
I'm setting up and invoice in word and have managed to figure out how to do the 'sum above' formula and also work it out so it adds VAT it is set out like below... £100 £100 £100 Sub total: £300 (sum above) VAT:??? Total: £352.50 (=B6*1.175) The one thing i want it to work out for me is the VAT as a stand alone total as we need to show this between the 2 values (sub total / total) so i thought it would just be a matter of adding a subtraction formula in the cell i want it then doing a eg. C6-C4 (total - subtotal) but i can't work out to do the formula! can anyone help - much appreciated if you can!!!! thanks can't find subtraction anywheere!!! |
|
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
How to add a subract field in a word
Why not just (=B6*0.175)?
"ATWR" wrote: Hi guys I'm setting up and invoice in word and have managed to figure out how to do the 'sum above' formula and also work it out so it adds VAT it is set out like below... £100 £100 £100 Sub total: £300 (sum above) VAT:??? Total: £352.50 (=B6*1.175) The one thing i want it to work out for me is the VAT as a stand alone total as we need to show this between the 2 values (sub total / total) so i thought it would just be a matter of adding a subtraction formula in the cell i want it then doing a eg. C6-C4 (total - subtotal) but i can't work out to do the formula! can anyone help - much appreciated if you can!!!! thanks can't find subtraction anywheere!!! |
|
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
How to add a subract field in a word
must be having a blonde moment. thanks Dean.
"DeanH" wrote: Why not just (=B6*0.175)? "ATWR" wrote: Hi guys I'm setting up and invoice in word and have managed to figure out how to do the 'sum above' formula and also work it out so it adds VAT it is set out like below... £100 £100 £100 Sub total: £300 (sum above) VAT:??? Total: £352.50 (=B6*1.175) The one thing i want it to work out for me is the VAT as a stand alone total as we need to show this between the 2 values (sub total / total) so i thought it would just be a matter of adding a subtraction formula in the cell i want it then doing a eg. C6-C4 (total - subtotal) but i can't work out to do the formula! can anyone help - much appreciated if you can!!!! thanks can't find subtraction anywheere!!! |
|
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
How to add a subract field in a word
Your welcome.
FYI, to answer your first question. =B8-B6 would give you the subtraction syntax you require. Best of luck DeanH "ATWR" wrote: must be having a blonde moment. thanks Dean. "DeanH" wrote: Why not just (=B6*0.175)? "ATWR" wrote: Hi guys I'm setting up and invoice in word and have managed to figure out how to do the 'sum above' formula and also work it out so it adds VAT it is set out like below... £100 £100 £100 Sub total: £300 (sum above) VAT:??? Total: £352.50 (=B6*1.175) The one thing i want it to work out for me is the VAT as a stand alone total as we need to show this between the 2 values (sub total / total) so i thought it would just be a matter of adding a subtraction formula in the cell i want it then doing a eg. C6-C4 (total - subtotal) but i can't work out to do the formula! can anyone help - much appreciated if you can!!!! thanks can't find subtraction anywheere!!! |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Word Field Type - Fill In Prompt Problem (Word Insert Field in .NE | Mailmerge | |||
| Wording in an entry field in Word that repeats in other field | Microsoft Word Help | |||
| Word: IF statement to merge a field only if another Field is popul | Mailmerge | |||
| Saving word document with field results not field codes | Microsoft Word Help | |||
| Can I limit and lock a word field (ab text field) ? | Microsoft Word Help | |||
Hybrid Mode
