How to write a formula in excel in Excel

How to write a formula in Excel?

How to add, substract, multiply or divide two numbers in Excel?

How do you calculate in Excel?

How do I create a function in Excel?

Answer

To make a calculation in Excel it is all about playing with cells (A1, B4, G11, ...) by creating an formula in a destination cell.

Like like writing in B2 the formula = (A1 + B1) * G11

(for formulas, depending on your country, you might have to change ; with , or the opposite

Other excel answers

 

 

You can find similar Excel Questions and Answer hereunder

1) Formula does not calculate in Excel

2) How do i apply a formula to an entire column in Excel

3) How can I calculate values applying complex Engineering formulas using Excel?

4) Excel 2010 vba replacement of application filesearch in Excel

5) I have a complex WorkSheet with lot of fields and data - How can I quickly find the cells that have formulas?

6) How do I copy a Table from one location to another and retain all formulas, formats and columnwidths?

7) Formula converts date to quarter and year in Excel

8) How can I hide Formula Bar and Headings using VBA?

9) How do I enter a formula in a cell using VBA (using Relative Reference)?

10) How do I enter a formula in a cell using VBA (using Absolute Reference)?

 

Here the previous and next chapter