LinkBack URL
About LinkBacks
We have list of firms and employees for six years and we need to give size no 1,2 or 3 for each firm based on average number of employees as the following :
size 1 for 1-9 employee
size 2 for 10-999 employee
size 3 for 1000-above
Thanks
We have list of firms and employees for six years and we need to give size no 1,2 or 3 for each firm based on average number of employees as the following :
size 1 for 1-9 employee
size 2 for 10-999 employee
size 3 for 1000-above
Thanks
Hello
you can use following formula
=IF(B588<=9,1,IF(B588<=999,2,IF(B588<=1000,3,0)))
__________________
Regards
Rahul Nagar
Founder of www.myshortcutkeys.com.
If you get the answer of your questions then please click EDIT in your original post then click on GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody! ....
Also
If you are satisfied by any members response to your problem please consider using the scales icon top right of thier post to show your appreciation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks