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
In excel
2007 you can have 64 nested IF.
No comments:
Post a Comment