NULL VALUES

[#1]

Hello everyone.

I have a problem with a null value, have an if statement where a comparison: if over 90 that puts "certified" if less than you put "non-certified" but if my field is empty (that is a base Excel) to make without information. In what way I can represent that it is null or empty field.

I only know this way, '' but it is not taking into account as null, how could you do to show "No information"?

[Anonymous · Accepted solution]

See if this helps:

if(len(trim(Field))=0, 'No Information', if(Field>90, 'Certified', 'Non-Certified'))

[#3]

Thank you very much for the help.

It worked to perfection!