Calculated Column hyperlink to open an InfoPath Form

This is very tricky. Here I need to create a calculated column where I use a Hyperlink image on which, when the user clicks , InfoPath form shall open in browser.

First you simply set the data type of the Calculated Column from Text to Number or Date/time and it will display the link as a hyperlink. Copy and paste the below code and edit the url based on your site and library.

="<a href ='http://{SERVER}/{SITE}/{LIBRARY}/Forms/template.xsn?openin=browser'><img src ='http://{SERVER}/{SITE}/PublishingImages/Applynow.png'></img></a>"

How to check a list column value is null in calculated column

=IF(NOT(ISBLANK([Column1])), IF(NOT(ISBLANK([Column2])),
IF([Column1]<=[Column2], "Success", "Failure"),""), "")

Nested IF Condition in Calculated Column

Assume that you have 3 approvers in a work flow and need to update the item status based on these approvers individual task outcome
1. Approver1_Status
2. Approver2_Status
3. Approver3_Status

You are updating a calculated column Status_Calc  based on approvers status.

And the scenario is if any approver rejects the request the item status need to set as Rejected and if the final approver approves, set item status as Approved

The [Status_Calc] value will be

=IF([Approver3_Status]="Approved","Approved",IF([Approver3_Status]="Rejected","Rejected",IF([Approver2_Status]="Rejected","Rejected",IF([Approver1_Status]="Rejected","Rejected"))))

Hope this helps...