CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formula
Tony M
Tony M

Reputation: 1762

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

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.

enter image description here

Upvotes: 0

Views: 1301

Answers (1)

player0
player0

Reputation: 1

this may work:

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

enter image description here

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

enter image description here

Upvotes: 0

Related Questions