I is recommended to always use the evaluate formula option in the formula tab for the understanding of the formula

It is nice that it is working for you.