| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | |||
Linear Mode
