Dividing after a long formula
 

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?

Thanks!

Hi JonathanK1

Try to do this:
Before :=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)/1500

Does it worked for you?

Dividing after a long formula
 

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 Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
Shikata ga nai...

Dividing after a long formula
 

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+K 2+L2)*0.5)/1500


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

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.

Dividing after a long formula
 

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...