The value of a name [Solved/Closed]

Report
Posts
8
Registration date
Thursday April 10, 2014
Status
Member
Last seen
July 1, 2014
-
Posts
8
Registration date
Thursday April 10, 2014
Status
Member
Last seen
July 1, 2014
-
Hello,


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.+

2 replies

Posts
2676
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 3, 2020
448
Hi Derrall,

What you are doing now is putting all your data in formula's.

Normally one would create a database with all the information and then use VLOOKUP formula to retrieve certain information.

Best regards,
Trowa
Posts
8
Registration date
Thursday April 10, 2014
Status
Member
Last seen
July 1, 2014

Thanks for the response, i just watched a couple of videos on vlookup, and ill get to work in seeing how efficient it is.

OR efficient i am with it, lol.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!