If . . .then . . . equation in form field

[Guest]

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}+10>160,"Advance amount can not exceed
$150.",=({Ref Text8}+10))
Where did I mess up?

 

[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

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Guest]

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!