Make sure that the A1 cell returns text "http://www.example.org"
Select A1 cell
Expected result: hyperlink cell A1 is defined by '=HYPERLINK("http://www.example.org")'
formula and creates "http://www.example.org" as URL
Make sure that the A2 cell returns text "Click here"
Select A2 cell
Expected result: hyperlink cell A2 is defined by
'=HYPERLINK("http://www.example.org";"Click Here")' formula and creates
"http://www.example.org" as URL
Make sure that the A3 cell returns text "http://www.example.org"
Select A3 cell
Expected result: hyperlink cell A3 is defined by
'=HYPERLINK("http://www.")&"example.org"' formula and creates
"http://www.example.org" as URL
Make sure that the A4 cell returns text "Click example.org"
Select A4 cell
Expected result: hyperlink cell A4 is defined by
'=HYPERLINK("http://www.";"Click ")&"example.org"' formula and creates
"http://www.example.org" as URL
Make sure that the A5 cell returns text "http://www.example.org"
Select A5 cell
Expected result: hyperlink cell A5 is defined by
'=HYPERLINK("")&"http://www.example.org"' formula and creates
"http://www.example.org" as URL
Make sure that the A6 cell returns text "Click http://www.example.org"
Select A6 cell
Expected result:hyperlink cell A6 is defined by
'=HYPERLINK("";"Click ")&"http://www.example.org"' formula and creates
"http://www.example.org" as URL
Make sure that the A7 cell returns text "Click"
Select A7 cell
Expected result: hyperlink cell A7 is defined by
'=MID(HYPERLINK("http://www.example.org";"Click here");1;5)' formula and creates
"http:" as URL
Make sure that the A8 cell returns text "http://www.example.org"
Select A8 cell
Expected result: hyperlink cell A8 is defined by
'=IF(TRUE();HYPERLINK("http://www.example.org");"something")' formula and creates
"http://www.example.org" as URL
Make sure that the A9 cell returns text "something"
Select A9 cell
Expected result: hyperlink cell A9 is defined by
'=IF(FALSE();HYPERLINK("http://www.example.org");"something")' formula and creates
"something" as URL
Make sure that the A10 cell returns text "1"
Select A10 cell
Expected result: hyperlink cell A10 is defined by
'=IF(FALSE();HYPERLINK("http://www.example.org");1)' formula and creates
"1" as URL
Make sure that the A11 cell returns Boolean result TRUE
Select A11 cell
Expected result: hyperlink cell A11 is defined by
'=IF(FALSE();HYPERLINK("http://www.example.org");1=1)' formula and creates
"1" as URL
Make sure that the A12 cell returns '#DIV/0!'
Select A12 cell
Expected result: hyperlink cell A12 is defined by
'=HYPERLINK("http://www.example.org")&(1/0)' formula and does not create a
hyperlink cell, because an error code would be part of the URL. The cell result is
'#DIV/0!'
Make sure that the A13 cell returns text "http://www.example.org"
Select A13 cell
Expected result: hyperlink cell A13 is defined by
'=HYPERLINK($B4)' formula, where B4 contains "http://www.example.org", and creates
"http://www.example.org" as URL