CODEWITHSUNDEEP
if-statementgoogle-sheetsimportgoogle-sheets-formulasubstitution
Rellif
Rellif

Reputation: 91

Importing text in Google Sheets using Importhtml

What should be changed to allow the IMPORTHTML to retrieve a text value?

I get this error message; "Function MULTIPLY parameter 1 expects number values. But "Distribution Rate" is a text and cannot be coerced to a number."

=if(isblank($A17),"",(substitute(index(importhtml("https://www.cefconnect.com/fund/"&A17,"table",2),2,1),"*",""))*1)

Upvotes: 1

Views: 98

Answers (1)

player0
player0

Reputation: 1

use:

=IF(ISBLANK($A17),,(SUBSTITUTE(INDEX(IMPORTHTML(
 "https://www.cefconnect.com/fund/"&A17, "table", 2), 2, 1), "*", )))

Upvotes: 0

Related Questions