Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.tables
Lord
 
Posts: n/a
Default Calculations in Word Tables

I have two problems.

First, I have a cell in a table in a Word Document. I want that cell, which
is bookmarked 'HTotal' to compare the numeric amount in another cell that is
bookmarked as 'CVATot' and if it's greater than 5000, show the total of
CVATot.

If CVATot 5000 CVATot makes it show as text and not numbers.

Second problem. Compare the amounts of two other cells, and show the value
of the higher amount in the current cell.

I am at my wits end with this.
  #2   Report Post  
Posted to microsoft.public.word.tables
Lord
 
Posts: n/a
Default Calculations in Word Tables

Never mind, I solved my problem. The Word help never mentions the use of
COMMAS. My formulae read as follows:

=IF(CVATot 5000,CVATot,0.00)

and

=IF(ImpInc AIATot,ImpInc,AIATot)

"Lord" wrote:

I have two problems.

First, I have a cell in a table in a Word Document. I want that cell, which
is bookmarked 'HTotal' to compare the numeric amount in another cell that is
bookmarked as 'CVATot' and if it's greater than 5000, show the total of
CVATot.

If CVATot 5000 CVATot makes it show as text and not numbers.

Second problem. Compare the amounts of two other cells, and show the value
of the higher amount in the current cell.

I am at my wits end with this.

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
Word should allow to 'divide' page by 3 or 4, not just 2 CandasK Page Layout 2 February 28th 06 10:16 PM
WP merge file to Word sstires Tables 4 February 14th 06 06:26 PM
How can Word display full path of a file in the title bar? SAsif Microsoft Word Help 1 January 26th 06 04:32 PM
Does Word have a QuickCorrect/Quick Word option like WordPerfect? CW New Users 2 December 20th 05 05:54 PM
In Word, how do I surpress headers and footers on page 2 Bill Microsoft Word Help 1 December 15th 05 06:13 PM


All times are GMT +1. The time now is 09:06 AM.

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

About Us

"It's about Microsoft Word"