Is it possible to identify which column is blank in a formula IF "THEN" message?

Question

Hi,

I have a formula like so :

If (IsNull([Date)]) AND !IsNull([Status]))
OR (!IsNull([Date)]) AND IsNull([Status]))
then "ERROR, Only one of these two columns have a value."
else Null()
Endif

Instead of having a then message saying "ERROR" can I identify which column is causing the error. Ie  Something like: Column for XX is blank while Column for XX has a value.

Any advice here

gabrielvilella · Accepted Answer

Maybe this?

IF (IsNull([Date)]) AND !IsNull([Status]))
THEN "Date null"
ELSEIF !IsNull([Date)] AND IsNull([Status])
THEN "Status null"
ELSE Null()
ENDIF