Home

Work arround for circular calculation. Calculate value within a calculated range

%3CLINGO-SUB%20id%3D%22lingo-sub-306114%22%20slang%3D%22en-US%22%3EWork%20arround%20for%20circular%20calculation.%20Calculate%20value%20within%20a%20calculated%20range%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-306114%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20guys%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20didn't%20know%20how%20to%20describe%20it%20in%20the%20subject.%20Basically%20the%20idea%20is%20to%20have%20this%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E200%3C%2FP%3E%3CP%3E300%3C%2FP%3E%3CP%3Ecalc_val%3C%2FP%3E%3CP%3E500%3C%2FP%3E%3CP%3E%3D1000%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20calc_val%20to%20be%20Total-200%20so%20the%20value%20will%20always%20make%20the%20total%20%3D%20200%3C%2FP%3E%3CP%3ENumbers%20will%20change%20monthly%20and%20have%20adjustments%2C%20so%20I'm%20looking%20for%20a%20formula%20to%20make%20the%20permanent%20calculation%2C%20but%20given%20is%20part%20of%20the%20sum%20to%20get%20the%20total%2C%20it's%20circular%20and%20I'm%20trying%20to%20find%20a%20way%20without%20using%20VBA.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20ideas%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-306114%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Joe78man
New Contributor

Hello guys,

 

I didn't know how to describe it in the subject. Basically the idea is to have this:

 

200

300

calc_val

500

=1000

 

I want calc_val to be Total-200 so the value will always make the total = 200

Numbers will change monthly and have adjustments, so I'm looking for a formula to make the permanent calculation, but given is part of the sum to get the total, it's circular and I'm trying to find a way without using VBA.

 

Any ideas?

 

 

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Edge insider Dev bypasses IE mode website list
HotCakeX in Enterprise on
4 Replies