d0dc24b12c52e514188d190bf1dada8a.png
above is a scenario i want to create for keeping track of my investment profile
so i created the spreadsheet format above.
I want to implement some simple programming so its more automated, so that all i have to do is enter in the "End" amount at the end of each day, in order to determine whether its a gain or a loss from the starting value.
how do i write the following formula/function?
i was attempting the following as: =if(G24>G23) then input the number value of G24-G23 in the Gain cell, but if G24<G23 then G24-G23 value will be input automatically into the Loss cell
how do I do that? Currently I can only do only one but not the other, as in I can only do gain but not gain and loss
Much appreciated
L
Bookmarks