Hey everyone I'm trying to use an IF statement to return TRUE if an account is one of 2 types and in shortfall using
=if(ri!portfolio<>{"type1","type2"},false,if(trim(ri!arrearsStatus)="Shortfall",true(),false()))
but if I pass type1 and Shortfall this produces as False, strangely if I use
=if(ri!portfolio<>{"type1"},false,if(trim(ri!arrearsStatus)="Shortfall",true(),false()))
passing type1 and shortfall returns True.
Any ideas how I would fix the first statement?
Thanks
Discussion posts and replies are publicly visible
if( or( ri!portfolio = "type1", ri!portfolio = "type2" ), if( trim( ri!arrearsStatus ) = "Shortfall", true(), false() ), false())
Thank you so much Krishna :)