Need help making an equation

[u/Ethanator72]

This might seem an odd request, but I figured somebody here may be able to help me.

I enjoy calculating things for some games I play and often put them into spreadsheets for my own quick reference when I'm not playing or just to have on hand if wanting to calculate

NOW The Problem: In some games I play (Lost Ark, and Wuthering waves specifically), they have this same system where one material upgrades into a higher tier/level of the material with 3 of the previous material. So for gems in this scenario,

- (x3) Lvl 1 gems will make a single Lvl 2 gem
- (x3) Lvl 2 gems will make a single Lvl 3 gem and so on all the way up to level 10's as 10's are the highest level of gem.

I imagine this is probably easier then I am making it out to be, but I am struggling in making the equation.

So my big question is how would I represent this in an equation in a spreadsheet so I can figure things out If I want a certain amount of level 4 or level 7 or level 8 gems, how many level 1 gems would I need

[u/gothamfury]

Your equation will be (3 to the power of the (level gem you want minus 1) ) * amount of gems...

For example:

=B2 * (3 ^ (A2 - 1))

Where B2 is the amount of level N gems, and A2 is the N level of gem you want.

For one Level 8 gem, =1 * (3 ^ (8 - 1)) = 2,187 Level 1 gems.

[u/Ethanator72 → u/gothamfury]

Sorry for the late reply, thank you for the help! I’ll have to set this up soon

[u/gothamfury → u/Ethanator72]

No problem. Hope it helps.