LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Member
 
Posts: 40
Default 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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula for dividing work Dok Excel Worksheet Functions 2 September 4th 09 01:42 AM
Formula for counting and dividing Preschool Mike Excel Worksheet Functions 1 May 13th 09 06:15 PM
SUMPRODUCT: dividing the formula of one cell by another. SW Excel Worksheet Functions 1 July 14th 08 11:12 PM
What is the formula for dividing-I have the total Susan Excel Worksheet Functions 1 August 2nd 07 01:29 AM
What is the formula for dividing a number by 4 in excel Blessingspoint Excel Worksheet Functions 1 January 13th 05 05:58 PM


All times are GMT +1. The time now is 12:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"