If and AND statement

[#1]

Hey guys,

STREET              NUMBER          COMPANY 

Lowland               5                        Datatec

Lowland               7                        Datatec

Lowland               10                      StrategicAnalysis

Buitenland             24                     Conecxion

Spoorweg              16                     InfoTec

Spooweg               20                      Datatec

Heuvel                   3                      Lifestyle

Milieu                    14                     BrainTec

Lowland                 8                       BrainTec

Milieu                     9                       Datatec

Heuvel                    6                      Datatec

Highland                 15                    Healthcaresolutions

Lowland                   11                   Healthcaresolutions    

From the table above I want to be able to say : IF COMPANY = Datatec AND STREET = Lowland AND NUMBER = 5, then a message should be displayed "The best HighTec Company" . Please any help on how to write these expression?                        

[MindaugasBacius · Accepted solution]

If(COMPANY = 'Datatec' and STREET = 'Lowland' and NUMBER = 5, 'The best HighTec Company', 'Other') as Score

This works for your needs.

[avinashelite]

try like this

if(COMPANY = Datatec AND STREET = Lowland AND NUMBER = 5,'The best HighTec Company')

[swuehl]

For example, create a text box with expression:

=IF( COMPANY = 'Datatec' AND STREET = 'Lowland' AND NUMBER = 5,'The best HighTec Company')

and also create a show condititon on layout tab:

=COMPANY = 'Datatec' AND STREET = 'Lowland' AND NUMBER = 5

This will show the message if you have limited the data set to only these values.

[#5]

Hey Avinash,

Thanks alot it worked.

Best,Simon