Formulas

[carol]

How do i hide a zero balance in word.

 

[Stefan Blom]

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.

 

[carol]

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]

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.

 

[carol]

Fantastic. It works great!! Thank you very much.

 

[Stefan Blom]

You are welcome.