If / Then Formula possibility?

Hi there everyone. I've been searching, and searching, and searching for my problem, and I really cant seem to find it anywhere until I stumbled across your awesome forums :D

Here is my dilemma: I'm helping out a community that puts out a role playing game by making a character sheet for their gaming system. It's normally a pen-and-paper type affair, but a few people have reached out to me and asked me to make it. Now, one thing that I really thought would be nifty would be to make it persistent. I know of the Excel basics, creating basic formulas and the such, but this is where I hit a brick wall.

For the character sheet, they normally have basic attributes on a 1-20 scale. These attributes are accomanied by a bonus. The only thing is those, while these bonuses go across a linear path (For attribute 1, it's -30, for 2 its -20, for 3 its -10, for 4 its -5 for 5 its 0....), I cant seem to figure out how to create some kind of If/Then formula for it....

Heres my example:

Brad makes a character that has a score of 9 for one of his attributes. The bonus given to someone with a 9 is a +10. What I'm looking to do is create a table that sees that 'If (c9)=9, Then (d9)=+10'...

Any assistence on this would be most excellent.....

-----------------------

And my second related issue...

Is there any possible way to do the above mentioned formula in relation to a drop down selection bar? It's the same thing here; To break it down simply, It would be excellent if there was a way for it to say If (a10)=Warrior, then (c10)= +10.



I know it must seem vague, I'm just kind of lost when it comes to this, and my friends (alleged excel experts) tell me I'm out of luck and not to bother with it....

Any help would be excellent! Thank you!

Hmmmmm that all seems pretty simple. So in essence what I will be doing is just creating a table of these for the cell formulas to look up to? So that would be applicable to both my questions then?!

Awesome! :D

I will most certainly try it out as soon as possible and report back here, if anyone has anything else to contribute, please do!!



EDIT::

Most excellent! The formula worked, and now I have a fully functional sheet! The tables used for table_array work well for an easy reference as well. It's almost complete, and the community is in awe over it!

:D Thank you so much everyone! Solved!

Oh, and I made sure to change the topic title, I'm sorry about that! :X