Ask For Filed - Use it in calculations

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JohnH - 07 Jan 2008 23:16 GMT

Word 2007 - I'd like to ask for a field then use it in calculations and then
have the calculated fields sum. For example:

Ask/prompt for - how many emps do you have? answer 5

blue cost 2 * 5 = $10.00
red cost 4 * 5 = $20.00
white cost 3 * 5 = $15.00

Total cost $$45.00

Need to do this in word because I'm going to wrap it around a bounch of text.

I cant figure out how to ask for the emp and/or use it in a calculation.

Hope this isn't a dumb - can't do that - question?

Thanks
John

Reply to this Message

Doug Robbins - Word MVP - 08 Jan 2008 01:40 GMT

Insert the following field constructions, using Ctrl+F9 to insert each pair
of field delimiters { }

{ ASK Employees "How many Employees" }

blue cost 2 * { ref Employees } = { = 2 * { ref Employees } \# "$0.00" }

red cost 4 * { ref Employees } = { = 4 * { ref Employees } \# "$0.00" }

white cost 3 * { ref Employees } = { = 3 * { ref Employees } \# "$0.00" }

Total cost= { = (2 + 4 + 3) * { ref Employees } \# "$0.00" }

Signature

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

> Word 2007 - I'd like to ask for a field then use it in calculations and
> then
[quoted text clipped - 17 lines]
> Thanks
> John

Reply to this Message

JohnH - 08 Jan 2008 13:15 GMT

Thanks much Doug. Just what I needed to know.
Thanks
John

Reply to this Message

Rate this thread: