if statement - usage of double if statements - solved

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

If I understand correctly, Put this formula in G27...

Formula:

Please Login or Register  to view this content.

lydte welcome to the forum

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(note: this change is not optional )