[Solved] Can only get % formula to work partway

[Leiif010]

I am trying to get a formula to calculate a % of 1s or -1s from active cells. I tried multiple ways and E3 and F3 have 2 different ways I tried. The formula works fine as long as row 4 is larger than 6 but I can not get it to work the other way. If 4 and 6 are even it should return 0, so Q3 should be 0 and it isn’t.

All I really need is the sum and the % rows but created the others to get the data for calculations. There are times when there is no number and I put an na in the cell so some of the total active cells are lower for some columns.

[Leiif010]

I got solutions as follows:
mariosv

Formula in M3:
=IF(M4>M6;(M4/M2);(IF(M6>M4);(M6/M2);0))
should be:
=IF(M4>M6;(M4/M2);IF(M6>M4;(M6/M2);0))
In IF(M6>M4), the close parenthesis is closing the IF.
Remember that function wizard can help to find these issues.

karolus

Hallo

=IF(M4=M6 ; 0 ; MAX(M4;M6) / M2 )

Thanks to both mariosv and karolus, both solutions work

[karolus]

Hallo
the other thread https://ask.libreoffice.org/t/formula-f ... way/130674