The following array formula in cell D1 assigns a grade to the risk factor, based on the current value in the linked cell. =IF(C1 > 50, "Acceptable", "Unacceptable") The following formula in cell D1 returns the exact value that is based on the current value in the linked cell: With these settings, the user can use the scroll bar to enter a precise number or click the area between the scroll bar and arrow to change the value in increments of 5. For example, if you create a risk factor scroll bar with the following properties: Use this value in a formula to respond to the value of the cell specified in the Cell link box that corresponds to the current position of the scroll box. The linked cell returns the current value corresponding to the position of the scroll box. In the Cell link box, enter a cell reference that contains the current position of the scroll box. For example, in a scroll box with a minimum value of 0 and a maximum value of 10, if you set the Page change property to 2, the value will increase or decrease by 2 (in this case, 20% of the value range of the scroll box) when you click the area between the scroll box and either of the scroll arrows. In the Page change box, enter the amount that the value increases or decreases and the degree to which the scroll box moves when you click the area between the scroll box and either of the scroll arrows. In the Incremental change box, enter the amount that the value increases or decreases and the degree to which the scroll box moves when the arrow at either end of the scroll bar is clicked. In the Maximum value box, enter the largest value that a user can specify by positioning the scroll box farthest from the top of a vertical scroll bar or the right end of a horizontal scroll bar. In the Minimum value box, enter the lowest value that a user can specify by positioning the scroll box closest to the top of a vertical scroll bar or the left end of a horizontal scroll bar. Greater than the Maximum value otherwise, the Maximum value is used. Less than the Minimum value otherwise, the Minimum value is used. In the Current value box, enter the initial value in the range of allowed values below that corresponds to the position of the scroll box in the scroll bar. To specify the control properties, do the following:
Note: Before you click Properties, make sure that the object for which you want to examine or change properties is already selected. Use a spin button, for example, to make it easier to enter a month, day, year number, or to increase a volume level. A user can also type a text value directly in the associated cell or text box. To increase the value, click the up arrow to decrease the value, click the down arrow. Spin button Makes it easier to increase or decrease a value, such as a number increment, time, or date. For example, use a scroll bar for a range of percentages that are estimates, or for adjusting color selection in a graduated way. Use a scroll bar for setting or adjusting a large range of values, or for cases when precision is not important. Typically, a user can also type a text value directly in the associated cell or text box. You can move through a page (a preset interval) of values by clicking the region between the scroll box and either scroll arrow. Scroll bar Scrolls through a range of values when you click the scroll arrows or when you drag the scroll box. You use a scroll bar or spin button to quickly enter or change a range of values. Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel 2007 More.
0 kommentar(er)
