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?