I use the below statement in ms excel and now want to have the same functionality in ms word.

=if(A1="text1",B1-3000,if(A1="text2",B1-4000))

B1 contains a number value, usually above 14000. I subtract from B1 based on what text (text1 or text2) I select in the drop down list in A1.

I want to create a form in MS word that does the same equation in my tables. I can't seem to figure out how to get it to do the equation based on what the text value of A1 is.

Can someone please point me in the right direction?

appreciate it.