I need help with creating a formula in steps $14-16,$ the rest of the previous steps ive already completed. Insert Option Buttons

Step$6.$ We need to add an Option $($radio$)$ button to the sheet. The button will choose the type of conversion you want to perform, i$.$e$.,$ Feet to Meter or Meters to Feet. They are typically used for selecting mutually exclusive options such that only one option amongst two or more choices can be selected.

Step$7.$ To add a button click Insert within the Developer ribbon and select Option Button under Form Controls. Cursor changes to a thin cross. Click anywhere on the worksheet to place the option button. See Figure $1.$

Butron

Step$8.$ Right$-$click the option button to select it and reveal options to edit it$.$ Select

Edit Text, and write Feet to Meters to replace the default text

Step$9.$ You can select the option button, copy and paste it to create a second option button, or just create another using the previous steps. Change its text to Meters to Feet

Step$10.$ Select the two option buttons and use their handles to move them to occupy the merged cells B$3$ & C$3.$ Arrange them suitably to give them a nice look.

$2.$ Set$-$up the option buttons

An event takes place whenever an option button is checked. This event then outputs a number that is unique to the option button. Your implementation will use this number to determine which button is checked and which conversion to perform. It would be best if you associated a cell to see and use the unique output of each option button.

Step$11.$ To do this association, you must right$-$click one of the buttons, ensuring the textbox appears around it$.$ Then, select Format Control. The Format Control dialogue box appears. Select the Control tab and click the Cell link box. Then click on cell B$2$ on the worksheet while the cursor is in the Cell link box. $$B$$$2$ should appear in the cell link box. Click OK to return to the worksheet. Repeat this procedure with the second option button. Make sure cell B$2$ is also linked to this option button.

Step$12.$ Check the option buttons one after another and note the numbers displayed in cell B$2.$ You will use these numbers in the next step. Name cell B$2$ conversion$\_$type.

$3.$ Conversion Formula and Headings

Step$13.$ Give the cell B$5$ the name input. This is where the value to be converted will be inputted.

Give the cell C$5$ the name output. It will hold the result of the conversion.

Step$14.$ Enter the conversion formula in cell C$5.$ The formula should implement this statement:

If conversion$\_$type $=$ number linked to the Meters to Feet option button, the output should be in Feet units else the output in Meter units.

It can also be written as

If conversion$\_$type $=$ number linked to Feet to Meters option button, the output should be in Meters unit, otherwise the output in Feet

Step$15.$ Now we must add the proper labels to our input and output fields. To do so$,$ enter a formula in cell B$4$ to display the input heading according to the selection made. It should implement:

If conversion type $=$ number linked to Feet button, the output should be the text "Feet", else the output is "Meters".

Step$16.$ Similar to Step $15,$ enter a formula in cell C$4$ to display the output heading depicting the conversion type.

Step $17.$ Style your sheet the similar to the screenshot shown below.