Hello,
I’ve attempted to replace empty cells with 100, 100%, or NULL and I am unable to get the syntax to work.
Some examples of what I’ve tried:
(1) ifelse({TOTAL SCORE},‘’,NULL,{TOTAL SCORE})
(2) ifelse({TOTAL SCORE},‘’,100,{TOTAL SCORE})
(3) ifelse({TOTAL SCORE},‘’,100%,{TOTAL SCORE})
(4) ifelse({TOTAL SCORE}=“”,100,{TOTAL SCORE})
All of the empty cells need to be replaced with 100 or 100%.
Thanks!