How to put IIF expression

  • Thread starter Thread starter zyus
  • Start date Start date
Z

zyus

I have this data in my tblsk

LA UN
10000 0
10000 5000
10000 10000

How to write an iif function if

UN = 0 ,"FD"
UN = LA,"ND"
UN >0<LA,"PD"

Thanks
 
IIf([UN]=0,"FD",IIf([UN]=[LA],"ND",IIf([UN]>0 And [UN]<[LA],"PD","")))
 
zyus said:
I have this data in my tblsk

LA UN
10000 0
10000 5000
10000 10000

How to write an iif function if

UN = 0 ,"FD"
UN = LA,"ND"
UN >0<LA,"PD"

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Back
Top