What are the benefits of using formula in excel?

Excel formulas are typically used to perform math functions and operations to data in an excel spreadsheet therefore eliminating the need for calculators for the user.

The benefits of the use of formulas are:

• Formulas can be copy/pasted to different cells and worksheets as so that users do not have to recreate the formula.
• As stated above, these eliminate the need for calculators therefore providing users a degree of ease and efficiency as all formulas are automated.
• As well as the above, the formulas are beneficial as they can be used for many cells of data at a time.

All in all, they simply allow the user to get work done more quickly and efficiently.

when you use formula in excel and change data at anytime, the output get changed automatically. 

So using formula saves your time a lot.

Helpful when having large amount of varaibles, it is always better than doing things manually.