Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
=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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using the COUNTA function | Excel Discussion (Misc queries) | |||
Calculating totals from COUNTA function | New Users to Excel | |||
Counta function question | Excel Worksheet Functions | |||
counta function can any one explain the example counting 2 | Excel Discussion (Misc queries) | |||
COUNTA Function not working =COUNTA(C3:C69,"NH") | Excel Worksheet Functions |