Help with IF statement and negative numbers

[Grammarjunkie]

I'm not an Excel novice, but my brain is just not seeing how to appropriately do this. I'm hoping maybe there's a function I've never used before, so I'm not aware of it. Or maybe I'm simply too close to the problem and not thinking outside of the box. But either way, my issue is follows:

In B19 I have a percentage, in D19 I have a percentage. In F19 I've subtracted D19 from B19 and condition formatted so that if the cell value is between -3.00% and 3.00%, it's green. Anything outside of that range is red. (i.e. - the difference between B19 and D19 can only have a 3% variance)

In cell H19, I need an IF statement to populate "APR within tolerance" if it's IN the 3% variance, "APR not within tolerance" if it's outside of that 3% variance.

The caveat being I can make anything over 3% make the cell read "APR within tolerance" effectively enough, but then anything less than 3% is "not within tolerance"... which isn't true. Anything to -3% IS "within tolerance."

Essentially, I need like the "Between" condition formatting, but formula form.

I hope this made sense. For the sake of clarity, this is what I currently have:

=IF(F19="","",IF(F19>3%,"APR not within tolerance", IF(F19<(3),"APR not within tolerance","APR within tolerance")))

I've also tried F19>(3). (Since I'm not sure if Excel counts larger negative numbers as less than or greater than. Neither worked.)

I hope I make sense, and I appreciate any advice.
Also, I apologize if this is a dumb question. I have no idea why I can't figure this out. haha.

 

[Grammarjunkie]

Totally just figured it out. Lol.

I was reading my post and it hit me:

=IF(F19="","",IF(OR(F19>3%,F19<-3%),"APR not within tolerance","APR within tolerance"))

I'm not sure why it wasn't obvious before.

I guess I was overthinking and needed a break.

Thanks for stopping by though!