How to determine if a cell has an image using google sheet formula

Question

How can I use a google sheet formula to determine whether a cell contains an image? I don't mean cells that have formulas such as =image(url), but rather cells that have just an image imbedded in the cell.

I've tried many things (=isText(), =isNumber() =isFormula(), =isNA(), =isURL(), =isBlank(), =isNonText()), but the closest I've been able to come up with is to combine isNumber() and isNonText() within an XOR(). However, as shown in the animated .gif (where A1 is a blank cell), this doesn't distinguish a cell containing an image from a blank cell.

Answer 1

this may work:

=(A3<>"")*(NOT(ISTEXT(A3)))*(NOT(ISNUMBER(A3)))=1

---

but note that you would need to use all possible states to really make sure ...so:

=ISNONTEXT(A3)*
 (NOT(ISBLANK(A3)))*
 (NOT(ISNUMBER(A3*1)))*
 (NOT(ISERROR(A3)))*
 (NOT(ISTEXT(A3)))*
 (NOT(ISFORMULA(A3)))=1