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

Posted on Jan 22, 2025 6:11 AM

Reply
1 reply
Sort By: 

Jan 22, 2025 5:06 PM in response to potzie

Since you only have either US or CAN stocks, you could simply the formula to state:

IF(B2="USD",E2*B28,E2)


So if B2 is "USD", F2 is the calculation with the exchange rate. If not, it means it must be "CAD" and thus F2 is set to E2.

Reply

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Trying to build the proper IF Statement

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.