Compare the field values

[kirrusk]

Hi,

I'm trying to find ,if any one of the fields having specific value (here values is No) then create a field with that value.

for example, 

Field1   Field2    Result field

Yes          No               No

No           Yes              No

No           No               No

Yes         Yes               N/A

Please suggest how can I achieve this.

[thambisetty]

| eval Result=if(Field1="No" OR Field2="No","No","NA")