Hyperlinking a cell with multiple variables to another cell in the same sheet using excel

Is there a way to merge an if statement and a hyperlink statement?

I have my if statement working smoothly but I am having issues with adding the hyperlink.

Examples provided below.

=IF(A2="Complete Blue Section","Blue Section Link",IF(A2="Complete Red Section"," Red Section Link",""))

and a hyperlink formula Not sure how to write it up. Found an example =HYPERLINK("#Sheet6!B44","Blue Questions")