Excel: calculate three-sentence - how it works
Related Videos: Excel IF Formula: Simple to Advanced (multiple criteria, nested IF, AND, OR functions) (May 2024).
A set of three can be solved very quickly with Excel. This practical tip shows you how to enter the formula in Excel and calculate tasks.
Solve three sentences with Excel
- In Excel, click a cell where you want to see the result. Type in your three-sentence formula, for example "= A1 * B1 / C1".
- If you then press the Enter key, no result is displayed yet. Your specified cells A1, B1 and C1 are not yet filled.
- Enter the values in the respective cells. Imagine the following three sentence, for example: Three programmers need 24 hours for a program. How long does it take five programmers?
- To solve this problem, enter the value 3 in A1 and in B1 24. In C1, enter the value 5.
- The result is now displayed in the cell with the formula.
In another practical tip, we will show you how to calculate percentages in Excel.