Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

What are the benefits of using formula in excel?

user-image
Question added by matununa jackson
Date Posted: 2016/12/26
Zaithwa Mpando
by Zaithwa Mpando , Systems Developer , Technovators

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.

ABHAY PRATAP SINGH
by ABHAY PRATAP SINGH , Senior Architect , Urban Ecosystems

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

So using formula saves your time a lot.

Anas Marei
by Anas Marei , Procurement Officer , UAE Special Olympics Foundation

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

More Questions Like This