Now we will see that how we can use formula in multiple worksheets
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
To view that which formula we used, we can just simply use 'Show Formulas'
option from FORMULAS tab.
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.
Solanki Ajay Narshibhai
Better for all learners and less expensive
Govind narayan vishwakarma
this is best free course for any beginner or advance level learner
great for me
Smit Kishor Situt
Informative and cristal & clear course!!!
Its to good thanks you
Such a amazing course and the best part about this course is that it is completely free and you can watch unlimited time and believe me this was best course if want to learn Excel it will teach you from scratch
Such a amazing experience with LearnVern ❤️