Vanilla Forums has been nominated for a second time in the CMS Critic "Critic's Choice" awards, and we need your vote! Read more here, and then do the thing (please).
Our new Indie Games subforum is now open for business in G&T. Go and check it out, you might land a code for a free game. If you're developing an indie game and want to post about it, follow these directions. If you don't, he'll break your legs! Hahaha! Seriously though.
Our rules have been updated and given their own forum. Go and look at them! They are nice, and there may be new ones that you didn't know about! Hooray for rules! Hooray for The System! Hooray for Conforming!

# Feral Solved an Excel Spreadsheet question

I've Done WorseRegistered User regular
edited March 2007
(Reposted from oDaM since I realized it's a pretty general question)

Anybody know who to right an excel formula that when you enter in the point buy cost for a stat it'll automatically output the proper stat. Alternatively if you could write it the other way around (Given stat x outputs cost y) that'd work too. My meager excel skills are failing me, likely because of horrible ability to properly write an equation that outputs the right results.

8 = 0
9 = 1
10 = 2
11 = 3
12 = 4
13 = 5
14 = 6
15 = 8
16 = 10
17 = 13
18 = 16

DevoutlyApathetic on
Trogg wrote: »
Not as positive as AIDS and cancer, but positive nonetheless.

PSN: QuipFilter
·

## Posts

• Who needs a medical license when you've got style? Registered User regular
edited March 2007
The way I'd do it is with a VLOOKUP.
On an unused sheet, create two columns like you have above:

8 0
9 1
10 2

etc. Let's say you put this on Sheet2!A1:B10

Then let's assume that your input cell is A1. On the output cell, create a formula like:

=VLOOKUP(A1,Sheet2!A1:B10,X)

The X above can be 1 or 2 depending on which column you want to be the output values.

every person who doesn't like an acquired taste always seems to think everyone who likes it is faking it. it should be an official fallacy.
the "no true scotch, man" fallacy.
·
• I've Done Worse Registered User regular
edited March 2007
Worked like a charm. Many thanks.

Trogg wrote: »
Not as positive as AIDS and cancer, but positive nonetheless.

PSN: QuipFilter
·
This discussion has been closed.