View Single Post
  #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.