Course Content

Course Content

Use of Formula in Worksheet

How To Use of Formula in Worksheet

Now we will see that how we can use formula in multiple worksheets together.

Suppose if you want to enter the total salary of any one person in a particular sheet, whose different salaries are written in different sheets, so for that we will simple use our usual formula method.

We will write equal to (=) in the cell where we want the total salary to be written and then proceed by selecting the cells from different sheets where the persons salaries are written.

This will give us the total salary of that particular person from different sheets together to our required cell.

Now if we have many different rows to calculate then and we can just simply use 'Sum' function for getting the total salary.

To get 'Sum' function we can simply press 'Alt+=' key from our keyboard, and after that select every cell from different sheets to get the total salary.

To view that which formula we used, we can just simply use 'Show Formulas' option from FORMULAS tab.

FAQs

A formula in Excel is an expression that works with values in a range of cells or a single cell. For example, =A1+A2+A3 calculates the sum of the values in cells A1 through A3. An argument of a function is a value that must be supplied to obtain the function's outcome in mathematics.

A formula is a set of instructions that tells the computer how to perform a mathematical operation on a given value. Formulas are most commonly employed in spreadsheet programmes like Microsoft Excel when it comes to computer software.

In your worksheet, you can create a basic formula to add, subtract, multiply, or divide data. Click the cell in which you wish to enter the formula on the worksheet. Type = (equal sign) followed by the constants and operators you want to use in the calculation (up to 8192 characters).

Worksheet formulas are built-in functions that are typed into a cell as part of a formula. When learning Excel, these are the most basic functions.

Formulas are not limited to just numbers; they can also be used with text and dates. For example, you could write a formula that calculates the number of days between two dates or counts how many times a word appears in an entire document.

Recommended Courses

Share With Friend

Have a friend to whom you would want to share this course?

Download LearnVern App

App Preview Image
App QR Code Image
Code Scan or Download the app
Google Play Store
Apple App Store
598K+ Downloads
App Download Section Circle 1
4.57 Avg. Ratings
App Download Section Circle 2
15K+ Reviews
App Download Section Circle 3
  • Learn anywhere on the go
  • Get regular updates about your enrolled or new courses
  • Share content with your friends
  • Evaluate your progress through practice tests
  • No internet connection needed
  • Enroll for the webinar and join at the time of the webinar from anywhere