Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
Hide Formula Results
On an ivoice template with multiple lines, I want to hide all zero results.
Ie if the invoice template has 5 lines but the invoice only has 2 items i want to hide the 0.00 results. If (qty shipped =0) then show"" otherwise show (qty*price) |
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
Hide Formula Results
Add a formatting switch to the Formula
\# "$,0.00;;" See "Formatting Word fields with switches" on fellow MVP Graham Mayor's website at http://www.gmayor.com/formatting_word_fields.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Bob" wrote in message ... On an ivoice template with multiple lines, I want to hide all zero results. Ie if the invoice template has 5 lines but the invoice only has 2 items i want to hide the 0.00 results. If (qty shipped =0) then show"" otherwise show (qty*price) |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change placement of translation results so they are in view. | Microsoft Word Help | |||
Formula Help | Microsoft Word Help | |||
Formula to Sum values in word table | Mailmerge | |||
I need a formula of amount of hours from two times in two cell? | Tables | |||
Formula in table - Creating a final total from sub-total cells | Tables |