I've been playing a lot of dark souls 2, and I'm trying to make a spread sheet to have the value for armor (to start). I plan on making drop downs for the different pieces of armor and when a certain piece is chosen to give values to different cells. For example if Armor A is selected +3 to fire, +3 to physical and so on. This is where the question comes.
Do i use a large if string? if(a2="Armor 2", 300, if(a2="armor 3", 305....) ect
I planned on doing it this way, and hiding the cells, and adding them later down the line
Is there an easier way?
Something along the lines of if(armor 2, (c3+50, c4+40, c5+60)
I do think i use the if command too much, but im used to it from If Then statements, i got used to them, so tell me if i shouldnt even be using it. Thanks in advance, again sorry if this is asked terribly or hard to read.+