% OF CHANGE

Hi guys,

I'm trying to calculate % of change using multi-row formula

if close if less than open

then % diff should be shown in negative

open	close
1,741	1,731
1,738	1,742
1,737	1,739
1,764	1,736
1,814	1,763

Datasets

Data Investigation

Accepted answers

Here is the new formula if you want to show positive diff as well.

Hi @BRRLL99, you can use this.

Thanks!

All comments

This solution should work for you. Let me know if any doubts.

Here is the new formula if you want to show positive diff as well.

hi,

i need both values,

if open > close then negative

if open < close then positive

Quick Links

Tags

This months top contributors

AkimasaKajitani 387

Hollingsworth 335