Attach a dynamic hyperlink based on environment

Hi NikolinoDE , thank you for the prompt response! While I am certainly looking for something like this I need to perform a conditional insert of the hyperlink, something like:

if env = dev

Add Dev URL to cell A1

else if env = prod

Add Prod URL to cell A1

The key problem is there is no way of knowing the excel sheet is downloaded from a dev environment or a prod one (except the request address) since there is no environment identifier in the workbook. However, if it is, I think your cell formula should work smoothly. Thanks a lot!