If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 G10,000) N( Max value 700 if B10,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 G10000 or B10000.. 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
|
|||
|
|||
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 G10,000) N( Max value 700 if B10,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 G10000 or B10000.. 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 |
Thread Tools | |
Display Modes | |
|
|