 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Programming / November 2004IF THEN
I have a form that I need to do an IF THEN statement for and I can't seem to get it to work. I need for text in one cell to trigger text in a different cell. Ex. IF Text1 = Option 1, THEN Text 2 = $50.00 IF Text1 = Option 2, THEN text 2 = $35.00 How do I write a formul for this?? Foyeti23 was telling us: Foyeti23 nous racontait que : > I have a form that I need to do an IF THEN statement for and I can't > seem to get it to work. I need for text in one cell to trigger text [quoted text clipped - 3 lines] > IF Text1 = Option 2, THEN text 2 = $35.00 > How do I write a formul for this?? Put this in Cell 2, insert the {} using CTRL-F9. When you are done, with the cursor inside the formula, do SHIFT-F9 to revert to the value instead of the code. {IF Text1 = "Option 1" "$50.00" ""}  SignatureSalut! _______________________________________ Jean-Guy Marcil - Word MVP jmarcilREMOVE@CAPSsympatico.caTHISTOO Word MVP site: http://www.word.mvps.org
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.