If Variable is null return result

[renjithpl]

Hi All,

I have a variable in input box. I want to create a formula where if the variable is empty then in a text box it should say "YES" else if value is entered then it should say "NO"

something like this =If(isnull(VinDocs), 'Yes') VinDocs is my variable

Thanks in advance. Please help me.

[renjithpl · Accepted solution]

i solved it, i got the right formula.

its =if(VinDocs='', 'Yes', 'No') it worked.

Thanks.