Hello Excel Gurus,
I have put the Formula to compare the cell based on the cell value using a threshold of ± 30%, in some cell Formula is working fine but in some it is not at all, I cannot figure this out need help.
Here is the Formula I am using;
Here is the screenshot of the formula results which is very weird
Here is the screenshot of the formula which is working correctly
Quick help would be much appreciated. Apologies if this question is too stupid to ask here.
BR
BeLoShI
I have put the Formula to compare the cell based on the cell value using a threshold of ± 30%, in some cell Formula is working fine but in some it is not at all, I cannot figure this out need help.
Here is the Formula I am using;
Code:
Formula =IF(OR(AND(H17=$F$16);AND(H17<=$F$16+($D$153*$F$16));AND(H17<=$F$16-($D$153*$F$16)));TRUE;FALSE)
Where
$D$153 = Threshold % i.e. 0.3
H17= actual cell to compare i.e. -44470
AND $F$16= absolute value to compare with i.e. -790
Here is the screenshot of the formula results which is very weird
Here is the screenshot of the formula which is working correctly
Quick help would be much appreciated. Apologies if this question is too stupid to ask here.
BR
BeLoShI