Trying to build the proper IF Statement
I am a Canadian and hold stocks in USD and CAD. I am trying to build a dividend table that calculates the CAD amount I will receive annually from my holdings. I want to build an IF statement that automatically uses the exchange rate at the bottom of the table to calculate the CAD equivalent and if the cell has CAD in it then it just uses that number in the cell.
What am I doing wrong in this example?
Mac mini, macOS 15.1