And what do you want to do if neither text1 nor text2 = A1? The following assume you want to deduct nothing in such cases:
{IF{REF Text1}= A1 {=B1-3000} {IF{REF Text2}= A1 {=B1-4000}} B1 \# ,0}
or:
{=B1-{IF{REF Text1}= A1 3000 {IF{REF Text2}= A1 4000 0}} \# ,0}
Results are expressed as whole numbers with thousands separators.



Note: The field brace pairs (ie '{ }') for the above examples are created in the body of the document via Ctrl-F9 (Cmd-F9 on a Mac) - you can't simply type them or copy & paste them from this message.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]