Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
Form fields and formula
I have created a table and used the form feature to put in fields with the
last cell doing a calculation formula. The one column I have put =Sum(B2:b22)*0.38. The second column is =Sum(C2:C22)*5.52. I then want another cell to add the results of these 2 formulas together, which it will not do. Does anyone know how to do this please, or alternatively how to formulate the one cell to do both tasks ie the formulas above and then add the results together. I know a spreadsheet would do this, but I like to work in Word as I can add graphics etc more easily. Would be grateful for some help please. Margaret |
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
Form fields and formula
Use
= (Sum(B2:b22)*0.38) + (Sum(C2:C22)*5.52) -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Margaret Upton" wrote in message ... I have created a table and used the form feature to put in fields with the last cell doing a calculation formula. The one column I have put =Sum(B2:b22)*0.38. The second column is =Sum(C2:C22)*5.52. I then want another cell to add the results of these 2 formulas together, which it will not do. Does anyone know how to do this please, or alternatively how to formulate the one cell to do both tasks ie the formulas above and then add the results together. I know a spreadsheet would do this, but I like to work in Word as I can add graphics etc more easily. Would be grateful for some help please. Margaret |
#3
Posted to microsoft.public.word.tables
|
|||
|
|||
Form fields and formula
Thank you so very much, that works perfectly.
Kind regards Margaret "Doug Robbins - Word MVP" wrote in message ... Use = (Sum(B2:b22)*0.38) + (Sum(C2:C22)*5.52) -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Margaret Upton" wrote in message ... I have created a table and used the form feature to put in fields with the last cell doing a calculation formula. The one column I have put =Sum(B2:b22)*0.38. The second column is =Sum(C2:C22)*5.52. I then want another cell to add the results of these 2 formulas together, which it will not do. Does anyone know how to do this please, or alternatively how to formulate the one cell to do both tasks ie the formulas above and then add the results together. I know a spreadsheet would do this, but I like to work in Word as I can add graphics etc more easily. Would be grateful for some help please. Margaret |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to calculate sum based on drop down form fields in Word | Tables | |||
Auto Update of formula fields | Microsoft Word Help | |||
Updating formula fields - XP vs 2003 | Microsoft Word Help | |||
formula to calculate form fill-in fields | Microsoft Word Help | |||
get mailmerge fields in an IF formula | Mailmerge |