Output of the =IF(COUNTA) Function
 

=IF(COUNTA(Original_Data!Y8:Z8)0,"test.jpg","")

=IF(COUNTA(Original_Data!Y8:Z8)0,"<img
src="images/shirts/large/check.jpg","")

I am using the function in line 1 to pull data from cells in a worksheet
called Original_Data.
I have tested the fuction using an output called test.jpg.
The function works and put's test.jpg in the correct cells in one worksheet
corresponding to cells in another worksheet that have data and ignores cells
that don't.

My problem is that I need the output to be:
<img src="images/shirts/large/check.jpg"

Rather than test.jpg

Could someone please advise me how to configure the basic function to
achieve this?
Thanks.

Output of the =IF(COUNTA) Function
 

Firstly, you missed out the quote marks aftere the closing brace before the
comma in the IF function.
Secondly, if you wish to include quote marks within a string, you need to
double them.

Try
=IF(COUNTA(Original_Data!Y8:Z8)0,"<img
src=""images/shirts/large/check.jpg""","")
--
David Biddulph

"Excel Helps" wrote in message
...
=IF(COUNTA(Original_Data!Y8:Z8)0,"test.jpg","")

=IF(COUNTA(Original_Data!Y8:Z8)0,"<img
src="images/shirts/large/check.jpg","")

I am using the function in line 1 to pull data from cells in a worksheet
called Original_Data.
I have tested the fuction using an output called test.jpg.
The function works and put's test.jpg in the correct cells in one
worksheet
corresponding to cells in another worksheet that have data and ignores
cells
that don't.

My problem is that I need the output to be:
<img src="images/shirts/large/check.jpg"

Rather than test.jpg

Could someone please advise me how to configure the basic function to
achieve this?
Thanks.

Output of the =IF(COUNTA) Function
 

Thanks, David
It works perfectly.


"David Biddulph" wrote:

Firstly, you missed out the quote marks aftere the closing brace before the
comma in the IF function.
Secondly, if you wish to include quote marks within a string, you need to
double them.

Try
=IF(COUNTA(Original_Data!Y8:Z8)0,"<img
src=""images/shirts/large/check.jpg""","")
--
David Biddulph

"Excel Helps" wrote in message
...
=IF(COUNTA(Original_Data!Y8:Z8)0,"test.jpg","")

=IF(COUNTA(Original_Data!Y8:Z8)0,"<img
src="images/shirts/large/check.jpg","")

I am using the function in line 1 to pull data from cells in a worksheet
called Original_Data.
I have tested the fuction using an output called test.jpg.
The function works and put's test.jpg in the correct cells in one
worksheet
corresponding to cells in another worksheet that have data and ignores
cells
that don't.

My problem is that I need the output to be:
<img src="images/shirts/large/check.jpg"

Rather than test.jpg

Could someone please advise me how to configure the basic function to
achieve this?
Thanks.