Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Circular Reference : Puzzle to be solved ...
Excel Gurus .. need inputs on this
The following is the struture... B is calcualted as 65% on G H @ 40% of B C ( Max Value 800) A ( 5% on B) S( s=G-B+H+C+A) G=T-(P1+E1+N) P1 (p1=12%B) E1(E1=4.75%B, if G<10,000) N( Max value 700 if B<10,000 if B10000, N=0) T( Input Value) in simple if we give value T, it should calcuate G value and also rest of them.. I did most of the automation but was not able to get consistant results .. especially at the time of G<10000 or B<10000.. I mean especially when the clause applies. Need your support.. if this can be written in excel or need to write a macro to solve it regards, Naresh |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Circular Reference : Puzzle to be solved ...
Why not send us your actual formula?
best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Naresh" wrote in message ... Excel Gurus .. need inputs on this The following is the struture... B is calcualted as 65% on G H @ 40% of B C ( Max Value 800) A ( 5% on B) S( s=G-B+H+C+A) G=T-(P1+E1+N) P1 (p1=12%B) E1(E1=4.75%B, if G<10,000) N( Max value 700 if B<10,000 if B10000, N=0) T( Input Value) in simple if we give value T, it should calcuate G value and also rest of them.. I did most of the automation but was not able to get consistant results .. especially at the time of G<10000 or B<10000.. I mean especially when the clause applies. Need your support.. if this can be written in excel or need to write a macro to solve it regards, Naresh |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Circular reference help | Excel Discussion (Misc queries) | |||
Why is this a circular reference? | Excel Discussion (Misc queries) | |||
Circular reference help! | Excel Discussion (Misc queries) | |||
Can this be solved? or am i dealing with circular reasoning? | Excel Discussion (Misc queries) | |||
Circular Reference??? | New Users to Excel |