Recognizing Different Text Typed in Cells.

I am working on an online Dungeons and Dragons Character sheet for the new version 5 that just came out.

In the game, there is an attack bonus that is based on the skill you're using while attacking and if you've been trained in the attack you're trying to make.

Here is my formula
=Sum((IF(H57="Yes"),S16,0),(IF(k57="Strength"),G14,IF((k57="Dexterity"),G17,IF((k57="Constitution"),G20,IF((k57="Intelligence"),G23,IF((k57="Wisdom"),G26,IF((k57="Charisma"),G29,)))))))

Excel is not recognizing that "Yes" or "Stregnth" or any of the others are just words typed into those boxes.

Is there a way to fix this?

(S16,G14,g17 and the likes are where all the values are stored on my sheet. These numbers are ok and work perfectly well with other equations on my document.)

Thank you!
Flame_Driven

It should recognize them. Can you upload the character sheet (Go Advanced> Manage Attachments)
In your formula, you want to close each IF statement after the respective cell, not before it.
=Sum((IF(H57="Yes"),S16,0),(IF(k57="Strength",G14),IF((k57="Dexterity",G17),IF((k57="Constitution",G20),IF((k57="Intelligence",G23),IF(k57="Wisdom",G26),IF((k57="Charisma",G29))
Does that formula work?

Here is the corrected formula in Q57 (assuming you want a 5)

=SUM(IF(H57="Yes",S16,0),(IF(K57="Strength",G14,IF(K57="Dexterity",G17,IF(K57="Constitution",G20,IF(K57="Intelligence",G23,IF(K57="Wisdom",G26,IF(K57="Charisma",G29))))))))


The formula in R8 is just a very extended Nested IF statement with some AND's thrown in.
AND is used when you want multiple things to be true , i.e IF(AND ("strength"<16, "strength">12), "use battleaxe", "use dagger")
There has to be alternatives to using such a complex nested IF.

This formula should work the same as the one in R8 except it's just a little bit shorter

=MATCH(Q10, 'Don't Touch!'!A2:A21)

Another option in Q57

=IF(H57="Yes",S16,0)+INDEX(G13:G30, MATCH(K57,C13:C30,0)+1)