#1
|
|||
|
|||
Help with IF statement in word 2010
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. |
#2
|
||||
|
||||
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] |
#3
|
|||
|
|||
Thank you very much. That solved my problem and helped me tremendously.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Help with IF Statement | limpbizkit | Excel | 4 | 02-24-2011 09:16 PM |
Invoice Statement | Shoshana3 | Word | 0 | 11-15-2010 03:02 PM |
if statement | piper7971 | PowerPoint | 1 | 08-19-2010 07:10 AM |
Help with IF statement! | CPelkey | Word | 1 | 04-12-2010 09:06 AM |
Have you seen this error statement? | nebb | Word | 4 | 12-01-2009 10:05 AM |