Quote:
Originally Posted by 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 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?