lundi 3 août 2015

Google Spreadsheet- Help- Cell Value Dependency

Hopefully I will not over complicate this and someone will understand what I'm trying to accomplish. I'm horrible at explaining things, so bear with me. I have two cells that need to work together. I'm trying to find some sort of hypothetical function I can use where the value of one cell reflects a numerical value based on the value of the other. I.E., if A2 is the cell I change periodically (manually type in the value) and A2 has a value of 1,2,3,4,5,6,7 or 8. B2's value changes to a predetermined value that is assigned to each number 1-8. B2's value is dependent of A2. E.g., A2=1 then B2=100; A2=2 then B2=150; A2=3 then B2=225. Make sense? Anything I try, I get an error, mostly 'circular dependency' Maybe listing the exact values and titles I'll be using will help get it across, if not, make me sound extra kind of special. A1=quantity B1=unit C1=level D1=points E1=TotalUnitPoints Hopefully my spreadsheet visual mockup will post just as it is on my screen. All I want to do is change the level and it reflect the proper point value for the level of a specific unit. The complication that first appears is different units do not have equivalent values per level, e.g., a mustang level 2 has a different point value than that of a camero level 2. However, this is not relevant as I intend to apply someone's "super awesome function" or series of "super awesome functions" to each unit individually. Now I know my initial description of this does not reflect these details and hopefully this addition has not made it worse.

A1=quantity B1=unit C1=level D1=points E= Total unit points

[ A B C D
1 QTY UNIT LVL PTS
2 2----- Mustg 2 150
3 0----- Cam 6 800
4 2----- Charg 2 125 ]

I want to be able to change C2 from "2" to "3" and it reflect in D2 as "225". Each unit only has 8 levels. So column C only has a value of 1-8. This is what I want to happen when C2 changes IF C2=1,D2=100; C2=2, D2=150; C2=3, D2=225; C2=4, D2=350; C2=5, D2=475; C2=6, D2=600; C2=7, D2=750; C2=8, D2=1000

Aucun commentaire:

Enregistrer un commentaire