(Msg. 1) Posted: Tue Aug 25, 2009 2:19 pm
Post subject: Word 2003 - IF Statement, Form Field Calculate Archived from groups: microsoft>public>word>tables (more info?)
Greetings,
I have a table in Word 2003 and would like to do an “IF” statement on
a Text Form Field, type - Calculation.
The problem is: If CellA multiplied by CellB is $150 or less, the
answer is $150; otherwise the answer is the result of CellA multiplied
by CellB.
The expression would be this in Excel 2003: =IF(SUM(D19*D21)
<150,150,SUM(D19*D21))
The expression would be this in Word 2003: *stumped*
I do not have the luxury of keeping Excel 2003 in the picture for this
document.
I have done Google searches for “IF” statements, formulas,
calculations, etc. And all “IF” calculations for Word 2003 lead me
to:
Anyone looking for a great tutorial should download MVP Macropods.
This person has amazing talent, simply an incredible tutorial . The
thoroughness of the project is remarkable.
Even though I found great resources and fantastic advice, I still come
up short on a valid Form Field Expression for this problem.
I have an example Word.doc if that would help, I do not mind emailing
it if that would be more helpful. Any help solving this dilemma is
greatly appreciated.
(Msg. 2) Posted: Tue Aug 25, 2009 9:05 pm
Post subject: Re: Word 2003 - IF Statement, Form Field Calculate [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Hi Stacy ,
In Excel, you could do also use:
=MAX(D19*D21,150)
In Word, you could use a formula field (rather than a calculation formfield) coded as:
{=MAX({=D19*D21},150)}
Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste
them from this message.
--
Cheers
macropod
[Microsoft MVP - Word]
"Stacy Birk" <sbirkhome.RemoveThis@gmail.com> wrote in message news:05e2f017-4224-4315-b594-0556cae22331@u38g2000pro.googlegroups.com...
Greetings,
I have a table in Word 2003 and would like to do an “IF” statement on
a Text Form Field, type - Calculation.
The problem is: If CellA multiplied by CellB is $150 or less, the
answer is $150; otherwise the answer is the result of CellA multiplied
by CellB.
The expression would be this in Excel 2003: =IF(SUM(D19*D21)
<150,150,SUM(D19*D21))
The expression would be this in Word 2003: *stumped*
I do not have the luxury of keeping Excel 2003 in the picture for this
document.
I have done Google searches for “IF” statements, formulas,
calculations, etc. And all “IF” calculations for Word 2003 lead me
to:
Anyone looking for a great tutorial should download MVP Macropods.
This person has amazing talent, simply an incredible tutorial . The
thoroughness of the project is remarkable.
Even though I found great resources and fantastic advice, I still come
up short on a valid Form Field Expression for this problem.
I have an example Word.doc if that would help, I do not mind emailing
it if that would be more helpful. Any help solving this dilemma is
greatly appreciated.
(Msg. 3) Posted: Wed Aug 26, 2009 9:22 am
Post subject: Re: Word 2003 - IF Statement, Form Field Calculate [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Thank You, macropod!
And especially for the 'note' part.
I have done the following:
Opened Document
Unprotected Document
Clicked Table, Insert Formula
In Formula Field typed "=MAX({=D19*D21},150)" (without the quotation
marks)
In the Format Field, selected "$#,##0.00;($#,##0.00)" (without the
quotation marks)
Clicked Ok
Received: "!Syntax Error, {" (without the quotation marks)
I gave elementary steps I know, please know I am not questioning your
intelligence but more so questioning my own with this process. Would
you mind correcting me on where I went wrong?
I greatly appreciate your help, macropod.
Stacy
On Aug 25, 7:47 pm, "macropod" <macro....TakeThisOut@invalid.invalid> wrote:
> Hi Stacy ,
>
> In Excel, you could do also use:
> =MAX(D19*D21,150)
>
> In Word, you could use a formula field (rather than a calculation formfield) coded as:
> {=MAX({=D19*D21},150)}
>
> Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste
> them from this message.
>
> --
> Cheers
> macropod
> [Microsoft MVP - Word]
>
> "Stacy Birk" <sbirkh....TakeThisOut@gmail.com> wrote in messagenews:05e2f017-4224-4315-b594-0556cae22331@u38g2000pro.googlegroups.com...
>
> Greetings,
>
> I have a table in Word 2003 and would like to do an “IF” statement on
> a Text Form Field, type - Calculation.
>
> The problem is: If CellA multiplied by CellB is $150 or less, the
> answer is $150; otherwise the answer is the result of CellA multiplied
> by CellB.
>
> The expression would be this in Excel 2003: =IF(SUM(D19*D21)
> <150,150,SUM(D19*D21))
>
> The expression would be this in Word 2003: *stumped*
>
> I do not have the luxury of keeping Excel 2003 in the picture for this
> document.
>
> I have done Google searches for “IF” statements, formulas,
> calculations, etc. And all “IF” calculations for Word 2003 lead me
> to:
>
> http://groups.google.com/group/microsoft.public.word.tables/browse_th... >
> AND
>
> http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=365442 >
> Anyone looking for a great tutorial should download MVP Macropods.
> This person has amazing talent, simply an incredible tutorial . The
> thoroughness of the project is remarkable.
>
> Even though I found great resources and fantastic advice, I still come
> up short on a valid Form Field Expression for this problem.
>
> I have an example Word.doc if that would help, I do not mind emailing
> it if that would be more helpful. Any help solving this dilemma is
> greatly appreciated.
>
> Stacy
(Msg. 4) Posted: Wed Aug 26, 2009 9:31 am
Post subject: Re: Word 2003 - IF Statement, Form Field Calculate [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
I should have specified that I did try to do this as well:
Go to the cell within the table.
CTRL-F9=max(CTRL F9=D19*D21 ,150)
And that did not work either. I am sorry for the double post, I
should have stated that as well.
(Msg. 5) Posted: Wed Aug 26, 2009 2:01 pm
Post subject: Re: Word 2003 - IF Statement, Form Field Calculate [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Thank you for sticking with me, macropod.
I did as you suggested and wrote (CTRL-F9 Twice for { } ): {=MAX
({=D19*D21},150)}
I received this: !Syntax Error, $
When I right clicked for field code, this appears: {=MAX
($374,696,150)}
When I ALT-F9 I see the code that I typed: {=MAX({=D19*D21},150)}
I double checked the table cell references, those are correct. Your
thoughts?
(Msg. 6) Posted: Wed Aug 26, 2009 5:05 pm
Post subject: Re: Word 2003 - IF Statement, Form Field Calculate [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Hi Stacy,
Where you want the calculation to go, press Ctrl-F9 twice, so that you get a nested pair of field braces, thus '{ { } }'. Then
fillin/around them so that you end up with '{=MAX({=D19*D21},150)}'
--
Cheers
macropod
[Microsoft MVP - Word]
"Stacy Birk" <sbirkhome RemoveThis @gmail.com> wrote in message news:ab7d8994-1525-431a-a1be-fe3b7349795f@b25g2000prb.googlegroups.com...
>I should have specified that I did try to do this as well:
>
> Go to the cell within the table.
> CTRL-F9=max(CTRL F9=D19*D21 ,150)
>
> And that did not work either. I am sorry for the double post, I
> should have stated that as well.
(Msg. 7) Posted: Wed Aug 26, 2009 6:05 pm
Post subject: Re: Word 2003 - IF Statement, Form Field Calculate [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Try
{=MAX({=D19*D21 \# 0 },150)}
In tests here, that got rid of the $ before the numbers being compared and
overcame the !Syntax Error, $
--
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, originally posted via msnews.microsoft.com
"Stacy Birk" <sbirkhome.DeleteThis@gmail.com> wrote in message
news:2cffd1c6-e840-47a3-924a-680176c17e22@13g2000prl.googlegroups.com...
> Thank you for sticking with me, macropod.
>
> I did as you suggested and wrote (CTRL-F9 Twice for { } ): {=MAX
> ({=D19*D21},150)}
>
> I received this: !Syntax Error, $
>
> When I right clicked for field code, this appears: {=MAX
> ($374,696,150)}
>
> When I ALT-F9 I see the code that I typed: {=MAX({=D19*D21},150)}
>
> I double checked the table cell references, those are correct. Your
> thoughts?
>
(Msg. 8) Posted: Thu Aug 27, 2009 11:54 am
Post subject: Re: Word 2003 - IF Statement, Form Field Calculate [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Thank You, Doug! Both you and macropod are amazing!
From what I can tell the ' \ # 0' is a formatting switch of some
sort?
Also, side question - on various forums around here I notice the
formula written sometimes has spaces, sometimes does not - do spaces
matter when writing a formula such as you all did above? Just curious
on that.
Thank you again you two - I am extremely grateful to the assistance.
All times are: Eastern Time (US & Canada) (change) Goto page 1, 2
Page 1 of 2
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office