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?