Ok, I'm working on a spread sheet that will let my faction play with the #s and such to optimize a city for revenue. Here is the thing, I have a question on one equation, the crime rate equation. It is written here as: CR = CL x (Sum of (Facility [A] x surface [A]) ) / (Sum of (Facility [B] x surface [B] ) ) x eTL / 0.83. Now, I'm using Excel, just wondering how I would put this in. I get

just straight with

CL x sum of A / sum of B x (eTL/0.83)

or grouped as

(CL x sum of A)/(sum of B x(eTL/0.83))

which is correct using excel?

**drastic**differences in crime rates and income when I enter it in different ways. I have two extream ways of entering it in, just wondering which one is correct:just straight with

CL x sum of A / sum of B x (eTL/0.83)

or grouped as

(CL x sum of A)/(sum of B x(eTL/0.83))

which is correct using excel?

____________