Thank you, guys!

I think I found a solution, not perfect but it seems that it works.
=IF((ABS(C6)250)+ABS(D6)10%,COUNT($E$5:E5,1),"{a }")


"David Biddulph" wrote:

In your condition test you are adding a logical (ABS(C6)250), which will
have a value of 0 or 1, to ABS(E6), and then comparing the total with 10%.
Is that what you're trying to do?
In other words you'll get the TRUE condition either if ABS(E6) is greater
than 10%, or if ABS(C6)250 [because in the latter case it doesn't matter
what ABS() value we add to the logical 1 result, it will already be above
the 10% threshold.]
If that's what you're trying to do, it might be clearer if you express it as
an OR.
--
David Biddulph

"Lisa" wrote in message
...
Hello,
I need your expertise. I have few tabs with the similar data, where (a) is
below scope. I want to order all the variances above the scope (a) in
consecutive numbers by ignoring the blanks and below scope items. I am
using
this formula but it doesn't work because it is counting a's.
=IF((ABS(C6)250)+ABS(E6)10%,COUNT($C$6:C6)&"","{ a}")
....