Find my approach as reference below and stored in attached workbook version 9.3
a. if null then 0: ifnull([Value],0)
if [if null then 0]=0 then 1
ELSEIF [if null then 0]=100 then 2
ELSEIF [if null then 0]=200 then 3
ColourID.twbx 8.3 KB
Thanks...this was helpful for me and my work!
You are welcome. Glad I could help out.