I'm having some issues trying to accomplish the below in a google sheet. What I'd like to have happened is:
IF Cell O1 has a value of "Yes" AND Cell E1 is <= 25,000
Cell P1 = "DEFM-HW-A"
OR Cell O1 has a value of "Yes" AND Cell E1 is > 25,000
Cell P1 = "DEFM-HW-B"
OR IF O1 = "No"
Cell P1 = "No"