Excel Complex condition
irl last edited by
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
and so on
ИНДЕКСon the substation matrix and dope of columns (replacements)