Can i put a formula in an IF THEN Else statement?

In the linked table, I would like to populate column H with a formula. The formula to be used is dependent on the value in column F. Each day, the number of rows and the number of possible values in column F can change. I thought vba would be the best approach to set this up but I'm having trouble with the code. Would this even be the way to start the code?

Sub Macro4()
Dim lastRow As Long
    lastRow = Range("H" & Rows.Count).End(xlUp).Row
    Label = Range("F2") = "AUD/JPY"