Google Sheets / Google Docs / Ultradox : couple of Coding issues and can't figure out why

If any one is familiar with all 3, please contact me and let me know if you have a means to chat.... Skye chat, Facebook Messages, anything.

I have a couple of issues that should work, but do not and I can not figure out why. One is a IF statement but they involve Ultradox as well as the other two so please be familiar with that as well.

This is time sensitive and I already lost the weekend to someone who wanted me to want this their way and not what the real issue was.

SpiritJewelry@msn.com