Hi everybody, I'm breaking my head to put together an excel formula, for my college work.
The table needs to validate 2 information. According to the number of employees and the sector, whether it is Industry or Commerce / services.
Industry:
Micro: with up to 19 employees
Small: 20 to 99 employees
Average: 100 to 499 employees
Large: more than 500 employees
Trade and Services
Micro: up to 9 employees
Small: from 10 to 49 employees
Average: 50 to 99 employees
Large: more than 100 employees
That is, in a cell I will have a number of employees, and with this information, I need to be verified if it is an industry or trade information that will also be in another cell. By then yes it can classify it as Micro, small, medium and large.
Solved by V. Y. in 14 mins