Posted: 10/20/2016 3:29 AM
Post subject: Google Spreadsheet Help
Quote
ventuz
He/Him
Player (126)
Joined: 10/4/2004
Posts: 940
So I got a spreadsheet set up, but I have no idea how to place in calculation function. They're too confusing to piece them together for me. How would I do that in simple way? What I want it to do is user input in yellow color, and data output in green. Calculation is ((Body price*# in F)+(Nature price*# in G)+(Blood price*# in H)+(Soul price*# in I)+Price of head)/xp in J https://docs.google.com/spreadsheets/d/1Lvd0wZnLfukJp8I5IfmMuDm8PfPqYfq2LmLkRbq_3Zg/edit?usp=sharing
Posted: 10/20/2016 3:33 AM
Quote
Invariel
He/Him
Editor, Site Developer, Player (171)
Joined: 8/11/2011
Posts: 539
Location: Toronto, Ontario
Arcade TAS of 2023
Body price is $B$4 Nature price is $B$5 Blood price is $B$6 Soul price is $B$7 For the rest, you want to start by highlighting E2 and multiplying by $B10 (note the lack of a $ beside 10) and then copying and pasting down the column. $ is basically "anchor" - no matter where you copy the formula to, whatever follows the $ will remain fixed.
I am still the wizard that did it. "On my business card, I am a corporate president. In my mind, I am a game developer. But in my heart, I am a gamer." -- Satoru Iwata <scrimpy> at least I now know where every map, energy and save room in this game is
Posted: 10/20/2016 4:14 AM
Quote
ventuz
He/Him
Player (126)
Joined: 10/4/2004
Posts: 940
*Edit -- I realized, I wasted time here hah.. Nevermind, No farther help needed. At least it was good learning experience.