Multiple 'IFs' in Microsoft Excel allow you to define multiple criteriaThe 'IF' example demonstrated below can be applied in many situations. Sometimes we wish to calculate the bonus based not only on the sales performance but also on the designation of the consultant. In some cases we may wish to give an employee a conveyance allowance and we wish to do so based not only on his salary but also on his position in the company. Here we use multiple 'if', along with, maybe, 'and' and 'or' functions. Microsoft Excel provides many possibilities with the 'if' function to calculate and analyze data as demonstrated in the Excel training video. In case you find it difficult to follow the concept of the multiple 'ifs', please refer the the 'if' function Excel training video. | |
|
| |