How to Create Complex Formula in Excel 2010

In this article I am going to explain about complex formula in Excel 2010.
  • 3390

Complex Formula in Excel 2010

In simple formula we work with one mathematical operation. Such as 10 + 20.  But when we want to do with more then one mathematical operation on the data then we use complex formula such as 10 + 20 - 30. In complex formula we use order operation. Order operation defined which operation calculate first and operation enclosed in parenthesis.

To creating complex Formula we have to follow following steps.

Step 1

Select the cell where we want to formula result.

complex1.jpg

Step 2

Type the equal sine (=).

Comples2.jpg

Step 3

Type the open parenthesis and type the value.

complex3.jpg

Step 4

Type the first mathematical operation.

complex4.jpg

Step 5

Type the second value and then after type the close parenthesis.

complex5.jpg

Step 6

Type the next mathematical operation then after type the third value.

complex6.jpg

Step 7

Press the Enter result will be show.

complex7.jpg

Ask Your Question 
 
Got a programming related question? You may want to post your question here
 

Categories

More Articles

© 2020 DotNetHeaven. All rights reserved.