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
Last edited by Miloud; 12-30-2008 at 05:47 AM.
Hello Miloud,
You can you following formula for the same.
=IF(A1<=9,1,IF(A1<=999,2,IF(A1<=1000,3,0)))
regards
__________________
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.
hello
i think the condition should be on B
Hello Miloud,
Please check your second post
hello
please check the attached file
hello
you are both right....
and yes if you change his "a" to "B" it will work fine
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks