Microsoft Excel Training Videos
Multiple 'IFs' in Microsoft Excel allow you to define multiple criteria
to get the results you want
The '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 training video. In case you find it difficult to follow the concept of the multiple 'ifs', please refer the the 'if' function training video.
Microsoft Excel Training Videos
