Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
Formulas
How do i hide a zero balance in word.
|
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
Formulas
Use a numeric picture switch to specify different formats for positive,
negative, and zero results. The following simple example with a formula field: { = 35 \# "00.00;(00.00);" } would display 35.00 (since 35 is positive). A negative result would display in parentheses, and a zero result would not display at all. -- Stefan Blom Microsoft Word MVP "carol" wrote in message news How do i hide a zero balance in word. |
#3
Posted to microsoft.public.word.tables
|
|||
|
|||
Formulas
Hi
Thanks very much, however it is still not working correctly. In my formula i have the following caluculation =d6*1.175-d6. (This is calculating the VAT on D6 then subtracting the amount, leaving just the VAT amount) . Where would i insert the numeric picture switch? Thanks "Stefan Blom" wrote: Use a numeric picture switch to specify different formats for positive, negative, and zero results. The following simple example with a formula field: { = 35 \# "00.00;(00.00);" } would display 35.00 (since 35 is positive). A negative result would display in parentheses, and a zero result would not display at all. -- Stefan Blom Microsoft Word MVP "carol" wrote in message news How do i hide a zero balance in word. |
#4
Posted to microsoft.public.word.tables
|
|||
|
|||
Formulas
Edit the formula directly in the document: Press Alt+F9 to see the field
code. You'll see something like this: { = D6*1.175-D6 }. At the end of the field code, just add \# "0.00;0.00;" (assuming 0.00 is the format you want for positive and negative results). Press Alt+F9 to hide field codes. Press F9 to update the field. -- Stefan Blom Microsoft Word MVP "carol" wrote in message ... Hi Thanks very much, however it is still not working correctly. In my formula i have the following caluculation =d6*1.175-d6. (This is calculating the VAT on D6 then subtracting the amount, leaving just the VAT amount) . Where would i insert the numeric picture switch? Thanks "Stefan Blom" wrote: Use a numeric picture switch to specify different formats for positive, negative, and zero results. The following simple example with a formula field: { = 35 \# "00.00;(00.00);" } would display 35.00 (since 35 is positive). A negative result would display in parentheses, and a zero result would not display at all. -- Stefan Blom Microsoft Word MVP "carol" wrote in message news How do i hide a zero balance in word. |
#5
Posted to microsoft.public.word.tables
|
|||
|
|||
Formulas
Fantastic. It works great!! Thank you very much.
"Stefan Blom" wrote: Edit the formula directly in the document: Press Alt+F9 to see the field code. You'll see something like this: { = D6*1.175-D6 }. At the end of the field code, just add \# "0.00;0.00;" (assuming 0.00 is the format you want for positive and negative results). Press Alt+F9 to hide field codes. Press F9 to update the field. -- Stefan Blom Microsoft Word MVP "carol" wrote in message ... Hi Thanks very much, however it is still not working correctly. In my formula i have the following caluculation =d6*1.175-d6. (This is calculating the VAT on D6 then subtracting the amount, leaving just the VAT amount) . Where would i insert the numeric picture switch? Thanks "Stefan Blom" wrote: Use a numeric picture switch to specify different formats for positive, negative, and zero results. The following simple example with a formula field: { = 35 \# "00.00;(00.00);" } would display 35.00 (since 35 is positive). A negative result would display in parentheses, and a zero result would not display at all. -- Stefan Blom Microsoft Word MVP "carol" wrote in message news How do i hide a zero balance in word. |
#6
Posted to microsoft.public.word.tables
|
|||
|
|||
Formulas
You are welcome.
-- Stefan Blom Microsoft Word MVP "carol" wrote in message ... Fantastic. It works great!! Thank you very much. "Stefan Blom" wrote: Edit the formula directly in the document: Press Alt+F9 to see the field code. You'll see something like this: { = D6*1.175-D6 }. At the end of the field code, just add \# "0.00;0.00;" (assuming 0.00 is the format you want for positive and negative results). Press Alt+F9 to hide field codes. Press F9 to update the field. -- Stefan Blom Microsoft Word MVP "carol" wrote in message ... Hi Thanks very much, however it is still not working correctly. In my formula i have the following caluculation =d6*1.175-d6. (This is calculating the VAT on D6 then subtracting the amount, leaving just the VAT amount) . Where would i insert the numeric picture switch? Thanks "Stefan Blom" wrote: Use a numeric picture switch to specify different formats for positive, negative, and zero results. The following simple example with a formula field: { = 35 \# "00.00;(00.00);" } would display 35.00 (since 35 is positive). A negative result would display in parentheses, and a zero result would not display at all. -- Stefan Blom Microsoft Word MVP "carol" wrote in message news How do i hide a zero balance in word. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formulas | Microsoft Word Help | |||
inserting formulas | Tables | |||
Using Formulas in a Table | Tables | |||
Formulas? | Mailmerge | |||
Formulas in a Table | New Users |