Hide Formula Results

[Bob]

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)

 

[Doug Robbins - Word MVP]

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