im wondering if you can help me, i believe i may have my syntax wrong for this 'if...null' expression.
im creating a list box, i want it to have 2 options: Exists or Does Not Exist:
=IF (IsNull([DATE], 'Does Not Exist', 'Exists')
basically, in the data, if the date is null then the inventory doesn't exist, otherwise it does exist. this statement does not work. anyone have any ideas?
I think you forgot to include bracket after Date
=IF (IsNull([DATE]), 'Does Not Exist', 'Exists')
if above doesn't work then use below
=IF (Len([DATE])>0, 'Exists', 'Does Not Exist')
thanks to everyone for the responses, this seems to have worked. however, the 'Does Not Exists' option (i.e. all the NULLs) remains grey and never lets me select this. any idea why that would be?