Hello,
I have a list with articles which have technical criteria. I would now like to have the criteria returned as text but the complicated bit for me is how I can show the different temperatures... I tried if functions but it didn't really work. Would anybody know how best to solve this? My Excel version is 2016.
Many thanks in advance.
<colgroup><col><col><col><col><col><col><col><col><col span="2"><col><col><col></colgroup><tbody>
</tbody>
If "Higher Temperature" is ticked the temperature for UL, ATEX and IECEx should be 60, else 55
I am looking for a formula which will return all the criterias which are ticked as a text in column M. The formula can either work with the material number or description
I have a list with articles which have technical criteria. I would now like to have the criteria returned as text but the complicated bit for me is how I can show the different temperatures... I tried if functions but it didn't really work. Would anybody know how best to solve this? My Excel version is 2016.
Many thanks in advance.
Material Number | Material Description | CE | UL | ATEX | IECEx | GL | MOT South | MOT NRTL | EAC | Higher temperature | Mechanical Support | Output |
028031 | BK1111 | ● | ● | ● | ● | ● | ● | CE, UL_60, ATEX_60 | ||||
045065 | EK1234 | ● | ● | ● | ● | ● | ● | CE, UL_60, ATEX_60, IECEx_60 | ||||
177357 | EK1111 | ● | ● | ● | ● | ● | ● | ● | CE, UL_55, ATEX_55, IECEx_55,GL,TÜV_Süd |
<colgroup><col><col><col><col><col><col><col><col><col span="2"><col><col><col></colgroup><tbody>
</tbody>
If "Higher Temperature" is ticked the temperature for UL, ATEX and IECEx should be 60, else 55
I am looking for a formula which will return all the criterias which are ticked as a text in column M. The formula can either work with the material number or description