Create a hyperlink to track the number once entered in a specific cell

[steve400243]

Hello, I need to create a way to track a number once its entered in a cell. For instance If a FedEx tracking number is entered in cell B1 - in Cell B2 I want the Hyperlink to track it to populate. Thanks in advance for your help.

 

[Fluff]

How about

=IF(B1="","",HYPERLINK("https://www.fedex.com/fedextrack/no-results-found?trknbr="&B1))

 

[steve400243]

Thank you Fluff - This will work for my needs. Appreciate your time, and cell formula!

 

[Fluff]

You're welcome & thanks for the feedback.