![]() ![]() Right-click the control, and press DELETE.Excel Online Alternatives: 25+ Spreadsheet and similar apps | AlternativeTo (function()() Skip to main contentSkip to site searchPlatformsCategoriesOnlineWindowsAndroidMaciPhoneLinuxiPadAndroid TabletProductivitySocialDevelopmentBackupRemote Work & StudyLoginSign up HomeOffice & ProductivityExcel OnlineAlternativesExcel Online AlternativesExcel Online is described as 'part of Office Online, is the online version of Microsoft Office Excel' and is a Spreadsheet app in the office & productivity category. If you have three or more options to evaluate in the same group of options, you can use the CHOOSE or LOOKUP functions in a similar manner. After a user selects one of the two options, the following formula in cell D1 evaluates to "Full-time" if the first option button is selected or "Part-time" if the second option button is selected. Use the returned number in a formula to respond to the selected option.įor example, a personnel form, with a Job type group box, contains two option buttons labeled Full-time and Part-time linked to cell C1. If you have two or more option groups on the same worksheet, use a different linked cell for each option group. The first option button returns a 1, the second option button returns a 2, and so on. Use the same linked cell for all options in a group. The linked cell returns the number of the selected option button in the group of options. In the Cell link box, enter a cell reference that contains the current state of the option button. ![]() Unchecked: Displays an option button that is cleared. In the Format Control dialog box, on the Control tab, you can modify any of the available options:Ĭhecked: Displays an option button that is selected. To format a control, right-click the control, and then click Format Control. Note: The size of the option button inside the control and its distance from its associated text cannot be adjusted. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |