Making a calculator in Excel for your business is a great idea if you have any process that requires numbers to be input and standard calculations that need to be done.
For example, working out selling price, given a certain gross profit percentage; or calculating a commission based on what type of item was sold.
Relying on manually doing these calculations is prone to error and slow.
With a purpose built calculator in Excel, you know the calculations will be done the same each and every time. You can set up data validation to ensure that the inputs are more accurate. Not having to input the calculation steps each time is much faster.
With Excel formulas you can input things like product type and have the calculator access price or commission values automatically, this again increases the accuracy of your calculations and makes updating to new values easier.
