Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
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
Posted to microsoft.public.word.tables
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word should allow to 'divide' page by 3 or 4, not just 2 | Page Layout | |||
WP merge file to Word | Tables | |||
How can Word display full path of a file in the title bar? | Microsoft Word Help | |||
Does Word have a QuickCorrect/Quick Word option like WordPerfect? | New Users | |||
In Word, how do I surpress headers and footers on page 2 | Microsoft Word Help |