Post #2005566
2026-05-04 03:04 UTC
@Hyperlynx You may find something useful under Sheet --> Named Ranges And Expressions
Replies (1)
-
@Hyperlynx@aus.social 2026-05-04 03:36
@kauer The thing is, if I've got my total Metallurgists in column AH, artisans in AI, soldiers in AJ and so on, and I have each colony on a row, I want to calculate alloy production for the colony as (eg) =(AH4/100)*+3 I can name AH as "Metallurgists", but for the colony in row 4 I can't put in =(Metallurgists4/100)*+3 , it doesn't accept that. Metallurgists[4] doesn't work either.