How to Use Spin Button Percentage in Excel (3 Easy Examples)

Get FREE Advanced Excel Exercises with Solutions!

This tutorial will demonstrate how to use the spin button percentage in Excel. In Microsoft Excel, we can use different methods to calculate the percentage of a numeric value with a formula. We can apply algebraic calculations or insert a function to meet our objectives. When you are performing complicated and powerful data analysis, where you need to change a certain value and by that, you have to analyze different results then, you need to use the spin button feature. The spin button gives you the freedom to change a certain cell value according to your wish. In this article, you will learn how to use the spin button percentage in Excel.


How to Use Spin Button Percentage in Excel: 3 Easy Examples

We’ll use a sample dataset overview as an example in Excel to understand easily. If you follow the steps correctly, you should learn how to use the spin button percentage in Excel on your own. The examples are

1. Determining Total Payable Using Spin Button

In this case, our goal is to learn how to use the spin button percentage in Excel. We can learn this by first creating a percentage column and then using it under a certain condition. To use percentage form, we have to learn to convert a normal numeric value into a percentage. Technically Excel will convert any input data into a percentage by multiplying it by 100 and adding a percentage symbol (%) on the right if you opt to choose percentage formatting. But you can also convert a number directly to a percentage value without letting it be multiplied by 100 in Excel. After that, you can easily insert the spin button percentage in Excel to make the changes and determine the changes within that. The steps of this method are as follows.

Steps:

  • First, arrange the dataset like the below image. In this case, we have ID, Name, Age, Amount, Interest Rate, Years, Periods, EMI, and Total Payable sequentially from cells B4 to B12.

Dataset to Use Spin Button Percentage in Excel

  • Then, select the Developer >> Insert >> Spin Button options.

Using Developer to Use Spin Button Percentage in Excel

  • Next, select the area you want to insert the spin bottle feature.

Selecting Area to Use Spin Button Percentage in Excel

  • After that, you will get the spin bottle button option.

Insert Spin Button to Use Spin Button Percentage in Excel

  • Furthermore, press right-click on the spin bottle button and select the Format Cells option.

Format Cells to Use Spin Button Percentage in Excel

  • Afterward, in the Format Control window, set the Current Value, Increment Change, and Cell Link accordingly and press OK.

Format Cells to Use Spin Button Percentage in Excel

  • Moreover, you will get the desired result in the percentage form like the below image. If you look at the result, then you will see that, though in the current value, we have inserted 4, you got the result in Excel as 400% in the image.

Result to Use Spin Button Percentage in Excel

So this is kind of a problem. What we need is basically a decimal value, as we know percentage means the ratio of a number to 100. For that reason, we will refer to a new cell for the spin button.

  • Now, in the E8 cell, insert a random value.

Value Add to Use Spin Button Percentage in Excel

  • Furthermore, press right-click on the spin bottle button and select the Format Cells Now, in the Format Control window, set the Current Value, Increment Change, and Cell Link accordingly, and press the OK button. If you have looked closely now we have connected the E8 cell with the spin bottle in this case.

Format Cells to Use Spin Button Percentage in Excel

  • Subsequently, insert the following formula in the C8 cell.
=E8/100

Following Formula to Use Spin Button Percentage in Excel

  • As a result, you have got the percentage result accordingly.

  • Then, insert the following formula in cell C11.
=PMT(C8/12,C10,C7,1,1)

  • In addition, after pressing the Enter button, you will get the result for this cell by using the PMT function.

  • Subsequently, insert the following formula in cell C12 using the multiplication of cells.
=C11*C10

Insert Formula to Use Spin Button Percentage in Excel

  • Finally, you will get the final result with the help of the multiplication of cells in Excel.

  • Now, if you use the spin bottle option and change the value of cell C8, then you will get the proper change in cells C10 and C11.

Thus, we have determined the Total payable with the help of the Excel spin button percentage.

Read More: Using Spin Button to Increment Decimal in Excel


2. Using Spin Button to Determine Marks in Percentage

Now, we want to use the spin button percentage in Excel. In Microsoft Excel, the spin button percentage is used to check if a condition is met and then the defined statements will be shown based on the given condition. In this article, you’ll learn how you can use spin button percentages efficiently with different criteria and by combining them with other functions in Excel. After using the spin button percentage with the proper conditions, you can convert the numeric value into a percentage. The steps of this method are as follows.

Steps:

  • First, arrange the dataset like the below image. Now, we have ID, Name, Total Marks, Mark Gained, and Percentage in sequentially cells B4, B5, B6, B7, and B8.

Dataset to Use Spin Button Percentage in Excel

  • After that, insert the spin bottle by following the steps of the first method.

Spin Button to Use Spin Button Percentage in Excel

  • Next, in the Format Control window, set the Current Value, Increment Change, and Cell Link accordingly and press OK.

  • Moreover, if you press the spin bottle then you will see that the value changes from 65 to 60.

  • Next, insert the following formula in the C8 cell.
=C7/C6

Insert Formula to Use Spin Button Percentage in Excel

  • Now, if you press the Enter button, you will get the result for this cell.

  • Finally, if you change the value of the C7 cell using the spin button option, then you will get the changes in the C8 cell.

Final Result to Use Spin Button Percentage in Excel

Hence, we have determined the Marks in Percentage with the help of the Excel spin button percentage.

Read More: How to Control Multiple Cells with Spin Button in Excel


3. Calculating Sales in Percentage

Now, we want to use the spin button percentage in Excel. In Microsoft Excel, the spin button percentage is used to check if a condition is met and then the defined statements will be shown based on the given condition. In this article, you’ll learn how you can use spin button percentages efficiently with different criteria and by combining them with other functions in Excel. After using the spin button percentage with the proper conditions, you can convert the numeric value into a percentage. The steps of this method are as follows.

Steps:

  • First, arrange the dataset like the below image. Again, we have ID, Name, Purchases, Sales, and Percentage of Sales in sequentially cells B4, B5, B6, B7, and B8.

Dataset to Use Spin Button Percentage in Excel

  • Next, insert the spin bottle and set the proper conditions by following the steps of the first method.

  • In addition, insert the following formula in the C8 cell.
=C7/C6

  • Next, after pressing the Enter button, you will get the result for this cell.

  • Furthermore, if you change the value of the C7 cell using the spin button option, then you will get the changes in the C8 cell.

Therefore, we have determined the Sales in Percentage with the help of the Excel spin button percentage.

Read More: [Solved!] Excel Spin Button Not Working


Download Practice Workbook

You can download the practice workbook from here.


Conclusion

Henceforth, follow the above-described methods and hopefully, these methods will help you to use the spin button percentage in Excel. We will be glad to know if you can execute the task in any other way. Follow the ExcelDemy website for more articles like this. Please feel free to add comments, suggestions, or questions in the section below if you have any confusion or face any problems. We will try our level best to solve the problem or work with your suggestions.


Related Articles

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Zehad Rian Jim
Zehad Rian Jim

Zehad Rian Jim is a dedicated professional with a BSc. Degree in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology. He's good with Microsoft Office and has written more than 80 helpful articles for ExcelDemy in the last year. Now, he makes fun and easy-to-follow Excel tutorials for YouTube as part of the ExcelDemy Video project. Zehad loves figuring out Excel problems, and his passion for learning new things in Excel shines through in... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo