Hi

Cells() syntax take row and column number parameters.

Try instead

If Range("D7").Value = "USD/JPY" Then

Range("I7") = Range("C13") * Range("H7")

End If
or
If Cells(7,4).Value = "USD/JPY" Then

Cells(7,9) = Cells(13,3) * Cells(7,8)

End If