how to enter equation in Excel

Q30. In Excel, how can I enter an Engineering or Mathematical equation like Binomial Theorem Equation in Excel?

To do it in Excel, here is the answer:

a) Under "Insert" tab, click on "Equation" -> "Binomial Theorm".

excel how to enter equation

b) The equation is displayed as below.

excel excel how to enter equation

c) To enter an equation not in standard list, insert a shape (Click on Shapes under "Insert" tab) and with shape selected click on "Equation". "Insert New Equation" (Refer first screenshot) will get activated.

A separate tab "Equation Tools" with all the available elements for generating Engineering and Mathematical formulas is diplayed. Use the elements as needed to generate the equation.

excel excel excel how to enter equation


You can find similar Excel Questions and Answer hereunder

1) Calling a macro from another workbook in Excel

2) How can I insert a watermark in my Worksheet?

3) In a Table , how can I remove duplicate records?

4) Formula does not calculate in Excel

5) How can I prevent edits on my worksheet by protecting it with a Password ?

6) How can I copy and rename a WorkSheet using VBA?

7) How can I dynamically add series to an existing chart using VBA?

8) How can I enter information in multiple cells simultaneously?

9) How can I have text autocomplete by typing in a short code for the text?

10) Vba list all files in a folder in Excel

11) How can I display fractions as it is in a cell (instead of displaying as a decimal)?

12) Split string into multiple columns in Excel

13) Find and count instances of a character in a string in Excel

14) Is there a way I can round the sales figure to the nearest 500?

15) How can I enter multiple lines of data in a cell?