On Mon, 15 Apr 2013 10:46:15 +0100, Jyothish wrote:

Stan Brown;1611225 Wrote:
On Fri, 12 Apr 2013 21:21:27 +0000, JonathanK1 wrote:-

I have the following:


=B2*3+C2*0.5+D2*2+E2*1.5+F2*2.5+G2*0.5+H2*0.5+I2*2 +J2*1.5+K2*0.5+L2*0.5+M2*2

But I'm trying to divide the whole shabang by 1500. So, I tried
adding
/1500 at the end, but no go. I tried googling it, but I can't seem to
find the answer. I want the total of it all to be divided by the
1500.
What am I doing wrong?-

Seriously?

What is the difference between 6+10/2 and (6+10)/2 ?



Stan,It's the order of operations
In 6+10/2, Division will be perfomed and then addition.
while for (6+10)/2, braces take preceedence and thus operation within
braces wil be done i.e 6+10 giving 16 and then division wil be perfomed.

Well, yes of course.

I guess I wasn't clear enough in my attempt to point out that the OP
needs to do exactly the same thing Excel that he would have to do in
grade-school arithmetic.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
Shikata ga nai...