View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
 
Posts: 3,718
Default 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