How about:
Formula:
=IF(OR(SIGN(U5)<>SIGN(AA5),ABS(AA5)>ABS(U5)),"ERROR",IF(U5<0,"LOAN","DEPOSIT"))
How about:
Formula:
=IF(OR(SIGN(U5)<>SIGN(AA5),ABS(AA5)>ABS(U5)),"ERROR",IF(U5<0,"LOAN","DEPOSIT"))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks