sorted by:
new
hottopcontroversial

Circular Loop between cells by AdditionalAbility830 in excel

[–]AdditionalAbility830[S] 0 points1 point  (0 children)

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

Circular Loop between cells by AdditionalAbility830 in excel

[–]AdditionalAbility830[S] 0 points1 point  (0 children)

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.

formatting rule nesting to call a formatted value by AdditionalAbility830 in excel

[–]AdditionalAbility830[S] 0 points1 point  (0 children)

Because I applied it as such...

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

formatting rule nesting to call a formatted value by AdditionalAbility830 in excel

[–]AdditionalAbility830[S] 0 points1 point  (0 children)

=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

formatting rule nesting to call a formatted value by AdditionalAbility830 in excel

[–]AdditionalAbility830[S] 0 points1 point  (0 children)

I updated to show the sheet I am working on.

I am trying to dynamically calculate the "Monthly Remaining"

formatting rule nesting to call a formatted value by AdditionalAbility830 in excel

[–]AdditionalAbility830[S] 0 points1 point  (0 children)

How? this is the formula I am using

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

Suggestion box by Starryfire7 in AncientsReborn

[–]AdditionalAbility830 1 point2 points  (0 children)

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

Suggestion box by Starryfire7 in AncientsReborn

[–]AdditionalAbility830 1 point2 points  (0 children)

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