Multiple IF or Nested IF function in Excel
The multiple IF function example 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.
=IF(B2>=90,"A", IF(B2>=70, "B", IF(B2>=60,"C","Work Harder)))
In the training
video we have assigned grades to students
based on the marks they obtain. If a student has greater than or equal
to 90% marks, he is assigned grade 'A' and so on
example: '=if(and(A2="senior consultant",
code example with modification:
consultant", B2>=200000), B2*10%, if(and(A2="junior consultant",
B2>=200000), B2*5%, "Not Applicable"))'.