Give up on my what ifs!

Hi! I have a relatively easy template I am creating for my team to use, where certain criteria has “yes” or “no” in the dropdow I created. Certain YES carry different weigh on a scale 1-5. So let’s say, my formula would say “if C25=“yes”,5, and so forth. But it doesn’t work. I’ve given up. Gemini tells me what ifs doesn’t work in these conditions but makes no sense to me. Anyways. Is there a website people go to ask/ pay excel wizards to help them? I am willing to pay. Welp!!!