As per your conditions may be this......
![]()
=IF(OR(AND(AA5>0,U5<0),AND(AA5<0,U5>0),AA5>U5),"Error",IF(U5<0,"LOAN","DEPOSIT"))
As per your conditions may be this......
![]()
=IF(OR(AND(AA5>0,U5<0),AND(AA5<0,U5>0),AA5>U5),"Error",IF(U5<0,"LOAN","DEPOSIT"))
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks