ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Display if cell contains data (https://www.excelbanter.com/excel-worksheet-functions/173462-display-if-cell-contains-data.html)

Excel Helps
Display if cell contains data
 
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

CLR
Display if cell contains data
 
=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

Teethless mama
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

Excel Helps
Display if cell contains data
 
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

CLR
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


All times are GMT +1. The time now is 08:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com