Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-13-2024, 05:44 AM
maw444 maw444 is offline Setting a value to be used based on an 'If' statement Windows 10 Setting a value to be used based on an 'If' statement Office 2019
Advanced Beginner
Setting a value to be used based on an 'If' statement
 
Join Date: Feb 2021
Posts: 40
maw444 is on a distinguished road
Default Setting a value to be used based on an 'If' statement

I have a template in which I want to repeat a value based on a command.

Example



There will be an ASK field which will ask if the person is Male or Female.

I then need to have several lines where I need to change the text to either
'she or he'.

I recall there is a way you can set a value based on the result of the ask field but cannot remember as it's a while - that way I can define the value and use it throughout!

Could someone please point me in the right direction
Reply With Quote
  #2  
Old 09-14-2024, 07:20 PM
macropod's Avatar
macropod macropod is offline Setting a value to be used based on an 'If' statement Windows 10 Setting a value to be used based on an 'If' statement Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,340
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

For a single location:
{IF{FILLIN "Gender" \* Caps}= "F*" "she" "he"}
or, if you're outputting the result in multiple locations:
{SET BkMk {IF{FILLIN "Gender" \* Caps}= "F*" "she" "he"}}
then:
{REF BkMk}
wherever you need the output.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Setting a value to be used based on an 'If' statement If statement based on Color Alaska1 Excel 3 06-18-2024 11:55 PM
How to hide/delete slides based on keyword in a separate text file based on AND|OR condition? rupd911 PowerPoint 0 02-22-2021 08:22 AM
Converting a Select statement in Excel to an update statement shabbaranks Excel Programming 5 10-31-2018 11:47 PM
Help with IF statement kevinU Excel 0 03-15-2017 02:11 PM
Add a statement sma Word 6 03-23-2014 10:30 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:02 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft