How to Create Complex Formula in Excel 2010
In this article I am going to explain about complex formula in Excel 2010.
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.
Select the cell where we want to formula
Type the equal sine (=).
Type the open parenthesis and type the value.
Type the first mathematical operation.
Type the second value and then after type the
Type the next mathematical operation then after
type the third value.
Press the Enter result will be show.
Got a programming related question? You
may want to post your question here