How to do match with double type variable and string in excel

Hi guys,

I have one double variable which i get from a webpage and what i want to do is , i need to search and find match for this double variable in specific row in excel.

Example here:
strIntRate2 = (CDbl(strIntRate)/strTenure)
**** This three variable is in double type

I try to do like this
IF strIntRate2 .Contains(RL(13).toString) to find the match in excel but it prompt me “Contains, is not a member of Double”. Can anyone help me to give a solution for this.

1 Like

Hey @user123mem

Just try equals = operator instead of contains.

Hope that helps

Thanks
#nK

ya its helps! Thank You!

1 Like

Cool @user123mem :slight_smile: :+1:

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.