LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 27
Default 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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using the COUNTA function JL1976 Excel Discussion (Misc queries) 1 October 26th 07 01:28 AM
Calculating totals from COUNTA function MW New Users to Excel 3 March 13th 07 04:53 PM
Counta function question Karen McKenzie Excel Worksheet Functions 10 October 5th 06 12:08 PM
counta function can any one explain the example counting 2 pete the greek Excel Discussion (Misc queries) 4 March 30th 06 10:27 AM
COUNTA Function not working =COUNTA(C3:C69,"NH") MikeinNH Excel Worksheet Functions 2 November 8th 04 01:19 AM


All times are GMT +1. The time now is 07:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"