I would greatly appreciate help with formulas to address the following two conditions:
1). The recipient cell is to equal the value posted to cell F82if cell F83 = “CRITICAL” and cell M83 = “X” …..if these conditions are not metthe recipient cell is to remain blank.
2). Therecipient cell is to...