Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
formula syntax information
I'm creating an invoice. Where can I find Formula Syntax information? Some
examples would be nice. "IF" specifically but I would prefer something broader. In "D1" { =(A1*C1) \# "$#,##0.00;($#,##0.00)" } works just fine but "IF" the result is $0.00 (because A1 and C1 are empty) then I want "D1" to be empty as well. Also "A1" is a numeric value (no problem) but "C1" is a dollar amount. How do I get "C1" to automatically format to "$#,##0.00" when numbers are entered but remain blank if empty (I can't find a solution in "Developer"). Also can information in one table be picked up by a formula in a different table of the same document if I give cell in the first table a name or does each table have its own identity. I can't believe information is so scarce (or hard to find) in this area. I have spent hours looking. I could regroup on Excel but I hate to give up. Many thanks in advance, COMLANSER |
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
formula syntax information
For a start, have you looked at these Help topics?
Field codes: = (Formula) field Perform calculations in a table Referencing cells in a table Examples of IF fields -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "COMLANSER" wrote in message news I'm creating an invoice. Where can I find Formula Syntax information? Some examples would be nice. "IF" specifically but I would prefer something broader. In "D1" { =(A1*C1) \# "$#,##0.00;($#,##0.00)" } works just fine but "IF" the result is $0.00 (because A1 and C1 are empty) then I want "D1" to be empty as well. Also "A1" is a numeric value (no problem) but "C1" is a dollar amount. How do I get "C1" to automatically format to "$#,##0.00" when numbers are entered but remain blank if empty (I can't find a solution in "Developer"). Also can information in one table be picked up by a formula in a different table of the same document if I give cell in the first table a name or does each table have its own identity. I can't believe information is so scarce (or hard to find) in this area. I have spent hours looking. I could regroup on Excel but I hate to give up. Many thanks in advance, COMLANSER |
#3
Posted to microsoft.public.word.tables
|
|||
|
|||
formula syntax information
Hi COMLANSER,
To see how to do all this kind of stuff (and lot's more besides), check out my Word Field Maths Tutorial, at: http://www.wopr.com/index.php?showtopic=365442 or http://www.gmayor.com/downloads.htm#Third_party -- Cheers macropod [Microsoft MVP - Word] "COMLANSER" wrote in message news I'm creating an invoice. Where can I find Formula Syntax information? Some examples would be nice. "IF" specifically but I would prefer something broader. In "D1" { =(A1*C1) \# "$#,##0.00;($#,##0.00)" } works just fine but "IF" the result is $0.00 (because A1 and C1 are empty) then I want "D1" to be empty as well. Also "A1" is a numeric value (no problem) but "C1" is a dollar amount. How do I get "C1" to automatically format to "$#,##0.00" when numbers are entered but remain blank if empty (I can't find a solution in "Developer"). Also can information in one table be picked up by a formula in a different table of the same document if I give cell in the first table a name or does each table have its own identity. I can't believe information is so scarce (or hard to find) in this area. I have spent hours looking. I could regroup on Excel but I hate to give up. Many thanks in advance, COMLANSER |
#4
Posted to microsoft.public.word.tables
|
|||
|
|||
formula syntax information
Thank you. It took a while to get back to this project but "Examples of IF
fields" took care of the issue. COMLANSER "Suzanne S. Barnhill" wrote: For a start, have you looked at these Help topics? Field codes: = (Formula) field Perform calculations in a table Referencing cells in a table Examples of IF fields -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "COMLANSER" wrote in message news I'm creating an invoice. Where can I find Formula Syntax information? Some examples would be nice. "IF" specifically but I would prefer something broader. In "D1" { =(A1*C1) \# "$#,##0.00;($#,##0.00)" } works just fine but "IF" the result is $0.00 (because A1 and C1 are empty) then I want "D1" to be empty as well. Also "A1" is a numeric value (no problem) but "C1" is a dollar amount. How do I get "C1" to automatically format to "$#,##0.00" when numbers are entered but remain blank if empty (I can't find a solution in "Developer"). Also can information in one table be picked up by a formula in a different table of the same document if I give cell in the first table a name or does each table have its own identity. I can't believe information is so scarce (or hard to find) in this area. I have spent hours looking. I could regroup on Excel but I hate to give up. Many thanks in advance, COMLANSER |
#5
Posted to microsoft.public.word.tables
|
|||
|
|||
formula syntax information
Hi Macropod,
Thank you and mil gracias. It took awhile to get back to this project. Your "Word Field Maths" addressed my immediate issue as well as anything that may cme up in the future. http://www.gmayor.com/downloads.htm#Third_party is now a bookmark. Cheers, COMLANSER "macropod" wrote: Hi COMLANSER, To see how to do all this kind of stuff (and lot's more besides), check out my Word Field Maths Tutorial, at: http://www.wopr.com/index.php?showtopic=365442 or http://www.gmayor.com/downloads.htm#Third_party -- Cheers macropod [Microsoft MVP - Word] "COMLANSER" wrote in message news I'm creating an invoice. Where can I find Formula Syntax information? Some examples would be nice. "IF" specifically but I would prefer something broader. In "D1" { =(A1*C1) \# "$#,##0.00;($#,##0.00)" } works just fine but "IF" the result is $0.00 (because A1 and C1 are empty) then I want "D1" to be empty as well. Also "A1" is a numeric value (no problem) but "C1" is a dollar amount. How do I get "C1" to automatically format to "$#,##0.00" when numbers are entered but remain blank if empty (I can't find a solution in "Developer"). Also can information in one table be picked up by a formula in a different table of the same document if I give cell in the first table a name or does each table have its own identity. I can't believe information is so scarce (or hard to find) in this area. I have spent hours looking. I could regroup on Excel but I hate to give up. Many thanks in advance, COMLANSER |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula field syntax for testing check box | Microsoft Word Help | |||
The syntax for the formula COUNT in Word | Tables | |||
Formula Syntax Error in Footer | Page Layout | |||
Formula - Syntax Error | Tables | |||
If Formula syntax error | Tables |