I need help automating an algorithm, where A is the Nr., that is freely inserted (i.e.: 12, 500, 175, 4, ...).
Cell C should recognize the number (as <100 to >5.000) from cell A, and the risk level accordingly on cell B, from No to High and present the result on cell C.
There is a second table...