View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default Display if cell contains data

Happy to help..............thanks for the feedback...........

Vaya con Dios,
Chuck, CABGx3



"Excel Helps" wrote:

Fantastic.
Thank you

"CLR" wrote:

=IF(COUNTA(A2:C2)0,"colors.jpg","")

Vaya con Dios,
Chuck, CABGx3




"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