I reversed it, I made it into an if function, if anyone else is wanting to know how to get a steady Plus/Minus from Gains and Losses this formula worked for me
=IF(C4<=B4,1-B4/C4,C4/B4-1)
5
solved Calculate Gain Loss Excel Percentage [closed]
I reversed it, I made it into an if function, if anyone else is wanting to know how to get a steady Plus/Minus from Gains and Losses this formula worked for me
=IF(C4<=B4,1-B4/C4,C4/B4-1)
5
solved Calculate Gain Loss Excel Percentage [closed]