Prism ICT

Default image

How to extract URL from hyperlink on Excel

Add a new module from developer tab then insert below code Function GetURL(pWorkRng As Range) As String 'Updateby20140520 GetURL =

If statement in excel

The main syntax for the IF function in Microsoft Excel is: IF( condition_here, [value_if_true], [value_if_false] ) If A1 equal to B1 =IF(A1=B1,