I want to change this function so that if AR4 is blank then the corresponding cell is also blank. Right now it is saying DNP. The function I am using is
=IFS(AR4>445, "P", AR4<446, "DNP")
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this communityI want to change this function so that if AR4 is blank then the corresponding cell is also blank. Right now it is saying DNP. The function I am using is
=IFS(AR4>445, "P", AR4<446, "DNP")
=IFS(ISBLANK(AR4),,AR4>445, "P", AR4<446, "DNP")