Formula to return string

[FARAZ QURESHI]

Hi,

I am quite new to word table calculations can anyone help me step by step in
devising a formula for a word table of the following sort:

=if(sum(above)>10000,sum(above)*10%,"Non-Taxable")

If not possible, any other suggestions would be appreciated.

Thanx!

 

[Suzanne S. Barnhill]

The syntax would be:

{ IF { = SUM(ABOVE) } > 10000 "{ = SUM(ABOVE) * .10 }" "Non-Taxable" }

 

[FARAZ QURESHI]

Thanx Suzanne,

But as requested earlier would you please provide me step by step
instructions as to how this action may be carried out or give me an
appropriate link/reference on net. The archives do help out in different
concepts but haven't found the detailed procedure.

--
Best Regards,
FARAZ A. QURESHI

The syntax would be:

{ IF { = SUM(ABOVE) } > 10000 "{ = SUM(ABOVE) * .10 }" "Non-Taxable" }

 

[Doug Robbins - Word MVP]

Use Ctrl+F9 to insert each pair of field delimiters { }. The balance of the
construction can simply be entered by using the corresponding keys on the
keyboard.

When you have completed entering the field construction, use Alt+F9 to
toggle off the display of the field codes.

--
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

Thanx Suzanne,

But as requested earlier would you please provide me step by step
instructions as to how this action may be carried out or give me an
appropriate link/reference on net. The archives do help out in different
concepts but haven't found the detailed procedure.