Dividing after a long formula

[JonathanK1]

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 addin
/1500 at the end, but no go. I tried googling it, but I can't seem t
find the answer. I want the total of it all to be divided by the 1500.
What am I doing wrong?

Thanks

 

[Mazzaropi]

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 addin
/1500 at the end, but no go. I tried googling it, but I can't seem t
find the answer. I want the total of it all to be divided by the 1500.
What am I doing wrong?

Thanks!

Hi *JonathanK1*

Try to do this:
BEFOR
:[/B]=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
*NOW.....:*=*(*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)/150

Does it worked for you

 

[Stan Brown]

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 ?

 

[Claus Busch]

Hi Jonathan,

Am Fri, 12 Apr 2013 21:21:27 +0000 schrieb JonathanK1:

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.

why don't you summarize the cells with the same multilicator?
=(B2*3+F2*2.5+(D2+I2+M2)*2+(E2+J2)*1.5+(C2+G2+H2+K2+L2)*0.5)/1500


Regards
Claus Busch

 

[Jyothish]

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 withi
braces wil be done i.e 6+10 giving 16 and then division wil be perfomed

 

[Stan Brown]

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.