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
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
Tabs and Dark Mode
cjc2112 in Discussions on
34 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies