Game Army builder

[Darth yoda]

Hi guys.

I'm stumped on how do make an army builder for Warhammer 40K.
You get XXXX points to spend on an army and each unit costs a certain amount.
Some units, such as captains, you buy one at a time, while others, such as warriors you buy a unit of 10 (for 130 points) BUT you can add more for 13 points each..........Up to a maximum of 20 (for warriors).
Then you can buy a second warrior unit, and on.....
The problem Im having is trying to get an error check or formula to check the minimum (and add 130 points), check the max, then see if any extras were purchased at 13 points each.

Like this:
10 warriors..................130 points
12 warriors..................130 plus an extra 26 (13 X 2)
15 warriors..................130 plus 65 (13 X 5)

You guys have helped me alot and I really appreciate the effort you put into it. So heres another toughie!!!!

 

[StephenCrump]

I'm not clear what the question is:

Your unit cost per warrior is 13 points, regardless of whether you buy in "boxes" of 10 or as individual units.

So for N warriors, your cost will be N x 13 points.

Perhaps you can't buy only two warriors without paying the 130 points box cost? So you want MAX(130,N*13)?

 

[Darth yoda]

Thanks for the response Stephen. Sorry for the poor explanation.
Some units have a minimum number to buy. For warriors it is 10 with a base cost of 130. But you can upgrade to a max of 20. Each unit above 10 costs 13 points.
For warriors you can't go over 20 so there has to be some sort of error check there.

I guess it would be something like (MIN(10,130)+N*13) IF N<20 ELSE redo ?????

 

[StephenCrump]

Do you mean:

=IF(AND(A1>=10,A1<=20,INT(A1)=A1),A1*13,"Invalid Number")

 

[Darth yoda]

Thanks again Stephen. I will try this as soon as possible and let you know how it works,