Tricky IF AND Conditional Formula Help

[Dexter11]

I am perplexed on how to write an IF formula for the following two conditions:

if amount in column A is over/under $10K and 10% in Var% column B, insert a "B" in column F
OR if column A is over/under $25K, insert a "B" in column F

I think one big confusion for me is how to write the condition of the over/under dollar amounts and percentages, i.e. over
$10,000 or < ($10,000) AND if column C percentage is > 10% or < (10%)

I'm still learning how to write complex formulas but I'm really stumped with getting this one to work.

Can anyone help guide me in the right direction?

 

[grizle]

ABS() takes the absolute value of the bracketed expression. That is the numerical value ignoring the sign. So, -10000 and +10000 will both be evaluated as +10000.

 

[moonfish]

So effectively, ABS(value)>10 is the same as saying OR(value > 10, value < -10). It's mostly a matter of convenience and ease of reading.