Excel Complex condition



  • Таблица There are two columns with A and B numbers. Please indicate how the formula can be written in column C so that the letter in the cell is marked according to the conditions in the table?



  • In case you don't want to scoop a lot. ИЛИ :

    (1) Make groups in the sub-standard matrix (0-4.0-8) (only for illustration) введите сюда описание изображения

    (2) Add columns for group A and B on the data sheet (through если(0-4.0-8)

    введите сюда описание изображения and so on

    (3) Used ИНДЕКС on the substation matrix and dope of columns (replacements) введите сюда описание изображения


Log in to reply
 


Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2