Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.tables
Terri Terri is offline
external usenet poster
 
Posts: 62
Default How to set a variable rate formula in Word 2007?

I'm want to create a letter that for example, but need a table that shows
amounts. For instance, I have a different rate for the number of chairs you
rent. If you have 100 chairs it is this rate, 150 chairs this rate. I need
the formula for the rates set up and then all I have to do is input the
number of chairs the client has. Can I do this in word or do I need to import
an excel spreadsheet?
  #2   Report Post  
Posted to microsoft.public.word.tables
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
Default How to set a variable rate formula in Word 2007?

Hi Terri,

You could do this in Word but, unless you're capturing the input via a formfield in a document protected for forms, there's no way
to make the calculation automatic. Other than that, the formula itself is much the same as you'd use in Excel - there are some
important syntax differences, though. For more information on this and how to perform a wide range of calculations in Word, check
out my Word Field Maths Tutorial, at:
http://lounge.windowssecrets.com/ind...owtopic=365442
or
http://www.gmayor.com/downloads.htm#Third_party


--
Cheers
macropod
[Microsoft MVP - Word]


"Terri" wrote in message ...
I'm want to create a letter that for example, but need a table that shows
amounts. For instance, I have a different rate for the number of chairs you
rent. If you have 100 chairs it is this rate, 150 chairs this rate. I need
the formula for the rates set up and then all I have to do is input the
number of chairs the client has. Can I do this in word or do I need to import
an excel spreadsheet?


Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Variable text field (Word 2007) Sesquipedalian Sam New Users 5 July 11th 09 05:45 PM
run time error 91 object variable or with block variable not set GJ Microsoft Word Help 0 August 5th 05 02:43 PM
how do I slow down the scroll rate for highlighted text in Word? jsclevel Microsoft Word Help 1 August 3rd 05 05:25 AM
How can I slow down the rate/velocity of the autoscroll in Word? Mike Microsoft Word Help 0 May 8th 05 07:09 PM
run time error 91 Object Variable or With Block Variable not set champcf Microsoft Word Help 3 January 6th 05 01:17 PM


All times are GMT +1. The time now is 02:01 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"