If & AND function Help

Hi Team,

I am looking to reduce manual work and errors over data management on a spreadsheet.

I have inputted a formula in column AE

Formula:

Please Login or Register  to view this content.

. Also added a conditional highlighting for column U

However, my output that i am looking for is that if the amount in column AA is Positive and column U is negative or and vice versa, column AE should throw a comment "ERROR"

Or if the amount in column AA is greater than U, column AE should throw a comment "ERROR"

Can you please help me with a formula for the same.

Hi - somehow the codes are not working. instead of adding all formulae on one cell, i thought of splitting the formula.

on column AC i will add this formula.

Formula:

Please Login or Register  to view this content.

However, this works only when the column AA> column U. But when the amounts are negative, then this formula does not work. Since -300 is > 2,300,000 numerically but not when you speak about payments. Here i can pay -2300 but i am paying only -300.
E.g. Row 34
This is where my formula breaks. Can you please help.