If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Problem with Formula
I have a table with headings, Item, No, Unit Cost and Total
I want to add a calculated field in the Total column which calculates No * Unit Cost for each Item but this is new ground for me. I've tried using ToolsCalculate and various formulas like{=Sum[No]*[Unit Cost]} but keep getting errors. Please can someone explain how to do this. Many thanks. |
#2
|
|||
|
|||
Problem with Formula
You will need to use cell referenced.
Your first row is the headings and your first column is for the item name. So the cells of interest are B2*C2, B3*C3, etc. In column D you will need formulas like: { =(B2*C2) } -- Greg Maxey/Word MVP See: http://gregmaxey.mvps.org/word_tips.htm For some helpful tips using Word. nospaminlich wrote: I have a table with headings, Item, No, Unit Cost and Total I want to add a calculated field in the Total column which calculates No * Unit Cost for each Item but this is new ground for me. I've tried using ToolsCalculate and various formulas like{=Sum[No]*[Unit Cost]} but keep getting errors. Please can someone explain how to do this. Many thanks. |
#3
|
|||
|
|||
Problem with Formula
Thanks a lot Greg.
Having experimented with this I don't seem to be able to make the calculations dynamic e.g. I need to press F9 to recalculate every time I make a change so reluctantly I think I'm better off creating the table in Excel so any changes are immediately recalculated. Thanks again though |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
conditional formatting: problem entering EOMONTH formula... | Jonathan Cooper | General Discussion | 0 | February 6th, 2006 09:34 PM |
conditional formatting: problem entering EOMONTH formula... | Jonathan Cooper | General Discussion | 1 | February 6th, 2006 09:28 PM |
INDEX & MATCH formula problem | securityman | Worksheet Functions | 5 | September 6th, 2004 04:25 AM |
Copy formula problem | AWilliams722 | Worksheet Functions | 0 | November 13th, 2003 10:37 PM |
Formula Bar Problem... | Cloaked | Setting up and Configuration | 3 | October 4th, 2003 01:04 AM |