I need help with a formula to track my investments.
Lets assume that the value in cell A1 is my initial investment and never changes.
But the value in cell A2, the current value of my account, can change based the current value of my investment (I put this value in when I check the current status of my account)
I need cell A3 to provide the difference of A1 and A2
I need it to tell me if my account is up or down by percentage
Example:
A1=100
A2= 50
A3 = -50%
Lets assume that the value in cell A1 is my initial investment and never changes.
But the value in cell A2, the current value of my account, can change based the current value of my investment (I put this value in when I check the current status of my account)
I need cell A3 to provide the difference of A1 and A2
I need it to tell me if my account is up or down by percentage
Example:
A1=100
A2= 50
A3 = -50%