IF function in a field syntax

[Dan]

Good day,

I have an order form designed to allow a user to fill it out in Word or
print and fill-out by hand. It is a table which includes the colums of
Quantity, Unit Price and Amount. For each cell of the Quantity column, I
have a form field with the bookmark Qty0, Qty1, Qty2, etc.

My formulas for the Amount cells are based on Quantity * Unit Price, or more
specifically Qty0 * C2, Qty1 * C3, etc. and they work fine when data is
entered in Quantity. For simplicity, I've omitted the syntax for numeric
format.

As an empty form, the Amount cells display $0.00. I want the Amount cell of
each row to display nothing if there is no value entered in Quantity. I
want to achieve something like this:

IF(Qty0="","",(Qty0*C2))

In other words: If Quanity is blank, display blank, otherwise calculate the
formula and display the result. For simplicity, I've omitted the syntax for
numeric format.

I know how to do this Excel and can find all sorts of resources for the IF
function syntax in Excel but not in Word.

Thanks for taking the time to help with this.

Dan

 

[Doug Robbins - Word MVP]

You can do it with a formatting switch alone

\# "$,0.00;;"

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

 

[Dan]

Doug,

Yep! That did it. Thank you :-D

You can do it with a formatting switch alone

\# "$,0.00;;"

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