Need help with a nested If Statement:
=IF(AND(NOT(AND(OR([Country]="BR",[Country]="DE"),[Plancode]="Interim")),[AfterAdj Comm]+[After Adj Bonus]<0,[Term Date]=""),[After Adj Comm],0)
I do not understand how to decipher the logic in the nested AND|NOT|AND|OR ...
need help...
thanks!
=IF(AND(NOT(AND(OR([Country]="BR",[Country]="DE"),[Plancode]="Interim")),[AfterAdj Comm]+[After Adj Bonus]<0,[Term Date]=""),[After Adj Comm],0)
I do not understand how to decipher the logic in the nested AND|NOT|AND|OR ...
need help...
thanks!