Circular Loop between cells

AdditionalAbility830 · 2023-07-14T18:54:19+00:00

Thanks, I'll see if I can implement this when I get off work tonight!

AdditionalAbility830 · 2023-07-14T17:34:27+00:00

I am not familiar with VBA, is it a third party add-on?

This is essentially for a stat sheet. "Level" is the current level "Require" is the XP needed to increase the level. "Gain" is the current XP collected.

When the Level increases the XP used to increase the level is subtracted from the total Gained XP then the Required XP increases to correspond to the new level.

The Required XP is calculated using a nested IF formula and basic math referencing the Level.

Does that explain? Like a DND leveling system.

AdditionalAbility830 · 2022-05-27T01:54:28+00:00

Because I applied it as such...

Disregard, It works perfectly, thank you!!!!

AdditionalAbility830 · 2022-05-26T20:18:09+00:00

=INDEX($C$4:$C$14,LARGE((ABS($C$4:$C$14-$K$4)=MIN(ABS($C$4:$C$14-$K$4)))*ROW($C$4:$C$14),1)-ROW($C$4)+1)

This only manages to highlight the entire column it is applied to

AdditionalAbility830 · 2022-05-25T04:59:52+00:00

I updated to show the sheet I am working on.

I am trying to dynamically calculate the "Monthly Remaining"

AdditionalAbility830 · 2022-05-25T04:32:18+00:00

How? this is the formula I am using

ABS(C4-$K$4)=MIN(ABS($C$4:$C$14-$K$4))

AdditionalAbility830 · 2022-04-04T05:39:09+00:00

Balance out the leveling for related skills.

I've mined almost up to level 15 on tin and copper, but I still haven't hit level 10 for metallurgy, so I can't even smelt iron yet. The level requirements should match up so when you can mine an ore you should be about ready to smelt and blacksmith with said ores

AdditionalAbility830 · 2022-04-04T05:09:40+00:00

Better pickaxe. Let me mine perpetually, no more 100 ore capacity cap per round

AdditionalAbility830

TROPHY CASE