Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-19-2009, 06:13 AM
Bird_FAT's Avatar
Bird_FAT Bird_FAT is offline Auto-updating basic math functions & cross-referencing tables Windows 7 Auto-updating basic math functions & cross-referencing tables Office 2007
Expert
 
Join Date: Apr 2009
Location: South East
Posts: 271
Bird_FAT is on a distinguished road
Default

Hey DMD,



I think this link here may be the final piece to the puzzle - it looks like most of it has been covered pretty thoroughly by FranklinBluth; So, I'm hoping that this bit on fields for 2007 should finish it off nicely!
Reply With Quote
  #2  
Old 11-19-2009, 10:26 AM
DMD DMD is offline Auto-updating basic math functions & cross-referencing tables Windows Vista Auto-updating basic math functions & cross-referencing tables Office 2007
Novice
 
Join Date: Nov 2009
Location: Iowa
Posts: 14
DMD is on a distinguished road
Question

Quote:
Originally Posted by Bird_FAT View Post
Hey DMD,

I think this link here may be the final piece to the puzzle - it looks like most of it has been covered pretty thoroughly by FranklinBluth; So, I'm hoping that this bit on fields for 2007 should finish it off nicely!
Bird: Thanks for your suggestion. I had not been to that particular page
before. The only think I gained from it though, was that I can press
cntrl + F9 to enter my formula instead of clicking on Formula. At the
end of the day, I still can't make the simple addition formula work.
Here is my original post:
I am trying to design a template for receipts with a math formula
always there: Subtotal, multiply times % of sales tax, then the
grand total. When I used Lotus WordPro this was fairly easy,
but in msWord 2007, Vista I haven't figured it out. I've tried the
"Insert" tab and equation. Also, the "Layout" tab with Formula.
Formula works one time, but it's not there in the template, the
next time I want to make a receipt. Thank you.
I'll be more spicific about what I'm doing. I have a Word 2007 document in which I have imported my own logo, in the top center.
In the upper left and upper right
I have rectangles in which to put a person's name, address, the date, etc.
Below that I have build a table with 2 columns & 10 rows. Cell B7 is my subtotal cell. There I would like the sum of cells B1 - B6 to appear. In B8
I would like to have the 6% sales tax of B7 appear. In B9 I would like to have the sum of B8 and B9 appear. When I press cntl + F9 the curly brackets appear and I type =sum(above) in them - then I save that formula and that is all I ever see. When I enter numbers in cells B1 through B6, they never show up in B7. Just the {=sum(above)}
is visible there. Thank you much for your help.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto referencing SharkAttack Word 5 02-17-2013 07:09 PM
Cross referencing maltesedog Word 0 02-13-2009 07:43 AM
Trouble updating a form TomCaesar Outlook 0 11-29-2006 10:52 AM
Auto-updating basic math functions & cross-referencing tables Error updating DC with WSUS karel Project 1 08-10-2006 06:19 AM
How to show help for addin functions? Movses Asatryan Excel 0 03-02-2006 05:29 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:36 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft