Office Expert

NESTED IF 

If you master the basic use of an IF function  ,you will eventually come to realize that there are times you need to expand it .

For example you are about to get a bonus from the company .Everyone is having the potential to get , but the company is  having more than a single condition to evaluate the bonus amount .Here we need to put more than one IF .We want to give bonus according to the Job rating to everyone except those who have a job rating less than 3

If the job rating is 4  or more you will get 5000 Rs Bonus.

If it is 3 you will get 2000 Rs Bonus

If it is less than 3 then your bonus is “0” ...get nothing ....

In excel 2007 you can have 64 nested IF.