Return Yes if value is present else NO

[risabhroy_03]

I have a field called [In BOM].

I want its value as Y or N.

If it finds any record then Y should be displayed else N.

Please help.

[stevejoyce]

Not sure i follow.  But maybe this:  If(count ([In BOM]) >0, 'Y', 'N')

[risabhroy_03 · Accepted solution]

I used this & it is working fine.

=if(([In BOM])='-','N','Y')