Formula Needed: Column E having written text put in. If the written text is in than it's a Low if its left blank it's a High.
Formula Needed: Column E having written text put in. If the written text is in than it's a Low if its left blank it's a High.
Try this:
=IF(ISBLANK(E1),"High","Low")