Hello all,
This is actually an access Formula, but im pretty sure someone with excel formula knowledge may know what this means:
What does the "<>" mean, please help! Further, can you please distinguish what the difference of these two forumals are telling me?
Example 1
Sum(IIf([cash_dp]<300 And [mkt_typ]<>'L' And [has_voa_payment]=0 And [status] & [det]<>'XBT' And [contr_orig]<>'E' And (([Line]='Inhouse' And [contr_orig]<>'N') Or ([Line]='Dayline' And [contr_orig]='N')),[sales_volume],0))
Example 2
Sum(IIf([cash_dp]<300 And [mkt_typ]<>'L' And [has_voa_payment]=0 And [status] & [det]<>'XBT' And [contr_orig]<>'E' And (([Line]='Inhouse' And [contr_orig]<>'N') Or ([Line]='Dayline' And [contr_orig]='N')),1,0))
Thank you very much!
Hendrix P.
Bookmarks