Angiv et område med hovedkonti til Excel-saldoformel

[t6d6]

I would like to be able to specify a range of general ledger account codes for the formula I_EOL_CUT_BAL_PDER.

I can see I can add a list but separating them with a semicolon, but can I specify a range?

[forums]

See:

New Excel consolidation options for Exact Online companies and general ledger accounts

Go to Dutch version With Invantive Control, you can easily consolidate and report on general ledger accounts and multiple Exact Online companies. This can be done using hundreds of additional Excel formulas for Exact, but also via mass downloads from more than 1,000 linked Exact APIs. This consolidation and reporting takes place in Excel, but in real time with the most up-to-date financial data from multiple administrations. For EUR 59 per month, you get Exact consolidation for up to 100 admin…

A range can be specified using ‘-’ (dash):

I_EOL_BAL_PDE_CLOSE(; 2020; 1; 12; “8000-8015”)

[forums]

Dette spørgsmål blev automatisk lukket efter mindst 1 uges inaktivitet, efter at en mulig løsning blev givet. Det sidste svar er blevet markeret som en løsning.

Hvis problemet opstår igen, bedes du stille et nyt spørgsmål via et separat emne. Inkluder venligst et link til dette emne i det nye spørgsmål ved at indsætte dets URL i teksten.