Hi Guys,
I need a formula that performs the below. It should be easy but I can't nail it.
IF E8 = BLANK (No value) then "custom text", otherwise (if not blank), is the value >6 if true "custom text" otherwise " " (no value).
I was thinking something like...
=IF(ISBLANK(E8),"CUSTOM...