Formula to prevent circular references

  • Thread starter Thread starter Excel_Oz
  • Start date Start date
E

Excel_Oz

Hi All,

I need help with the following information. I have some calcs to run
however I keep getting circular references. The information is below.
I get a circular reference at "c" and another one at "f". Does someone
have a formula / array function that can work this out accurately
without the circular reference?

Thanks

Package 100,000.00 a
Sal Sac Super (2,295.86) b
Sal Sac Super Employee (4,147.30) c =5% of f
RemServ Admin Fee (35.22) d
93,521.62 e =a+b+c+d
Base 82,946.00 f =e-g
Employer 10,575.62 g =12.75% of
f

Total cross check 100,000.00 i
 
You could calculate Base like this:

Base=(Package-Sal Sac Super-RemServ Admin Fee)/(1.0+Sal Sac Super
Employee%/100+Employer%/100)
or as numbers Base=(100000-2295.86-35.22)/(1.0+0.05+0.1275)

Then Employer=0.1275*Base and SSSE=0.05*Base

Charles
___________________________
The Excel Calculation Site
http://www.decisionmodels.com
 
Back
Top