grade item formula with null

grade item formula with null

by bruno silva -
Number of replies: 0

Hello everyone, I have a question, I have a grade category and I need, through a formula, to validate if the grade of another grade category is null, but I couldn't find a way to put null in the formula. Has anyone ever needed this?

I tried using the following formula, but it doesn't work because null is not a number

"=if(and(Grade1>=0;Grade1<=10;Grade2>=0;Grade2<=10);max(Grade1;Grade2);Grade)"

Localization grade item formula