IF(AND(ISNUMBER(SEARCH())) Function

Hello Everyone,

I have been working on a macro for a report we run at work, and am currently running into an issue. The function below is supposed to be printing a "status" in column P, but it is not printing accurately. I have also posted screenshots to help illustrate the problem.

Formula:

Please Login or Register  to view this content.

In the picture below, please note that in cell O2 and O6, the amounts are $810 and $1,080, which are included in the formula, and should display "Increase w/Fee" in column P, but they are not. What am I doing wrong? Thank you in advance.

Excel 6.JPG

I suspect this may be the cause

AND(O2=810,O2=1050,O2=1080,

If O2 is 810 how can be 1050 as well and even 1080 ?
That should probably be an OR not and AND

Hard to critique from an image but

AND(O2=810| O2=1050| O2=1080| (N2<=0)))| should be an OR. O2 can't be 810 and 1050 at the same time. Not sure how N2 fits in. Might need

AND(ISNUMBER(SEARCH("VA"| J2)| (N2<=0)) |OR(O2=810| O2=1050| O2=1080))