Display if cell contains data
=IF(COUNTA(A2:C2)0,"colours.jpg","")
"Excel Helps" wrote:
I need to display an image file name in a column if a range of adjacent cells
contain data as this example: If the adjacent cells are blank, I don't want
to display the image file name.
Is there a function to do this?
Red White Black Image
white colours.jpg
red colours.jpg
red white back colours.jpg
|