## Formula in Excel 2016

### Using Solver

Solver tool allows you to specify multiple adjustable cells and constraints on the values that the
adjustable cells can have, generate a solution that maximizes or minimizes a particular worksheet cell,
generate multiple solutions to a problem.

### Goal Seeking

Goal seeking is a useful feature that works in conjunction with your formulas. If you know what a formula
result should be, Excel can tell you which values of one or more input cells you need to produce that
result.

### Calculating the difference between two time stamps

Because time stamps are represented as serial numbers, you can subtract the earlier time from the later time
to get the difference.

### Calculating the Number of Work Days between two dates

When calculating the difference between two dates, you may want to exclude weekends and holidays.

### Excel Formula Evaluator

If you would like to better understand how some of these complex array formulas work, consider using a handy
tool -

**Formula Evaluator**:### How to avoid misleading numbers

Applying a number format to a cell doesn't change the value, but only how the value appears in the
worksheet. Formatting can play a joke with you, e.g., sum of values seems incorrect because Excel displays a
limited number of decimal places and their sum is not equal to the real sum.

### Basic Formula operators

There are several operators that could be used in formulas.

### Using the formula bar as a calculator

If you simply need to perform a calculation, you can use the

**Formula**bar as a calculator.### Referencing cells outside the worksheet

Formulas can refer to cells in other worksheets-and the worksheets don't even have to be in the same
workbook. Excel uses a special type of notation to handle these types of references.

### Referencing cells outside the worksheet

Formulas can refer to cells in other worksheets-and the worksheets don't even have to be in the same
workbook. Excel uses a special type of notation to handle these types of references.