[Gabriella777_2]

I am unsuccessfully attempting to create a form that adds form field Ref
Text8 with 10 dollars and give a help command if the calculation tallies more
than $160.
However all I got was $0.
My equation was =if({Ref Text8}+10160,"Advance amount can not exceed
$150.",=({Ref Text8}+10))
Where did I mess up?
--
Thanks and God bless you and yours,
Gabriella777_2

[Graham Mayor]

Assuming Text8 actually contains a number, then insert a field

{ IF{ =({ REF Text8 } +10) } 160 "Advance amount can not exceed $150" "{
=({ REF Text8 } +10) \# $,0}" }

using CTRL+F9 for each field bracket pair.


--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Gabriella777_2 wrote:
I am unsuccessfully attempting to create a form that adds form field
Ref Text8 with 10 dollars and give a help command if the calculation
tallies more than $160.
However all I got was $0.
My equation was =if({Ref Text8}+10160,"Advance amount can not exceed
$150.",=({Ref Text8}+10))
Where did I mess up?

[Gabriella777_2]

Thank you, thank you, thank you thank you . . . .
oh and did I say
thank you thank you thank you
As you can probably guess : ) it worked (once I typed it correctly.

Thanks again and again for your help! : ) from ear to ear!
--
Thanks and God bless you and yours,
Gabriella777_2



"Graham Mayor" wrote:

Assuming Text8 actually contains a number, then insert a field

{ IF{ =({ REF Text8 } +10) } 160 "Advance amount can not exceed $150" "{
=({ REF Text8 } +10) \# $,0}" }

using CTRL+F9 for each field bracket pair.


--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Gabriella777_2 wrote:
I am unsuccessfully attempting to create a form that adds form field
Ref Text8 with 10 dollars and give a help command if the calculation
tallies more than $160.
However all I got was $0.
My equation was =if({Ref Text8}+10160,"Advance amount can not exceed
$150.",=({Ref Text8}+10))
Where did I mess up?