calculations in excel

Question

I am looking to make a calculator in excel to work out how many of a part i would need based on information inputted.

E.G. a window is 1200x1500. brackets are required every 200 so 27 would be required

Answer 1

Hello @Ben Foubister

Welcome to the Microsoft Q&A Community! 

Thank you for contacting us. If my understand is correct, you would like to create an Excel calculator that determines the number of brackets required based on the dimensions of a window and the spacing interval between each bracket.  

In this case, here are the steps and the recommended formula to help you complete this calculation accurately. 

For example, I have a new Excel worksheet and I enter the following information: 

• Cell A2: Window width (for example, 1200) 
• Cell B2: Window height (for example, 1500) 
• Cell C2: Required bracket spacing (for example, 200) 

To calculate the total brackets needed according to the spacing provided, enter the following formula in Cell D2: =CEILING((2*(A2+B2))/C2,1) 

This formula works by calculating the total perimeter of the window frame. It does this by adding the width and height together, multiplying the result by two, and then dividing the perimeter by the bracket spacing you specify. The result is then rounded up to the nearest whole number to ensure that the required number of brackets is sufficient to cover the entire perimeter. 

I hope you find this information clear and helpful in resolving the issue. 

Feel free to correct me if there are any misunderstandings and keep me informed about the progress. 

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".  

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.