How do you enter a complicated formula in Excel?
In order to perform a complex function, there is a standard order of operations in it. The first step is to put the specified portion of the formula in parentheses. For example, we need to add the contents of cell C5 and C6, then multiplying it with the data of B6. The derived formula would be =(C5+C6)*B6.