If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Formula for a column
In the table below: is there a way to combine column (A x
B) and column Rating into one equation. As an example: formula in Column A x B is column A times Column B. The formula in column "Rating" is column A x B x 10 divided by the max (A x B column of all the computers). So how can I combine A x B column and Rating Column into one formula Name A B A x B Rating Computer 1 3.6 9.7 34.7 9.3 Computer 2 3.73 10.0 37.3 10.0 Computer 3 2.8 7.5 21.0 5.6 Computer 4 3.2 8.6 27.5 7.4 Computer 5 3.2 8.6 27.5 7.4 Computer 6 2.8 7.5 21.0 5.6 |
#2
|
|||
|
|||
Hi!
Try this: =ROUND((B2*C2)/SUMPRODUCT(MAX(B$2:B$7*C$2:C$7))*10,1) Copy down as needed. Name A B A x B Computer 1 3.6 9.7 34.7 3.6 * 9.7 = 34.92 Biff -----Original Message----- In the table below: is there a way to combine column (A x B) and column Rating into one equation. As an example: formula in Column A x B is column A times Column B. The formula in column "Rating" is column A x B x 10 divided by the max (A x B column of all the computers). So how can I combine A x B column and Rating Column into one formula Name A B A x B Rating Computer 1 3.6 9.7 34.7 9.3 Computer 2 3.73 10.0 37.3 10.0 Computer 3 2.8 7.5 21.0 5.6 Computer 4 3.2 8.6 27.5 7.4 Computer 5 3.2 8.6 27.5 7.4 Computer 6 2.8 7.5 21.0 5.6 . |
#3
|
|||
|
|||
Thanks Biff. It works. Now I just need to figure out
multiple column version of table. So, thanks -----Original Message----- Hi! Try this: =ROUND((B2*C2)/SUMPRODUCT(MAX(B$2:B$7*C$2:C$7))*10,1) Copy down as needed. Name A B A x B Computer 1 3.6 9.7 34.7 3.6 * 9.7 = 34.92 Biff -----Original Message----- In the table below: is there a way to combine column (A x B) and column Rating into one equation. As an example: formula in Column A x B is column A times Column B. The formula in column "Rating" is column A x B x 10 divided by the max (A x B column of all the computers). So how can I combine A x B column and Rating Column into one formula Name A B A x B Rating Computer 1 3.6 9.7 34.7 9.3 Computer 2 3.73 10.0 37.3 10.0 Computer 3 2.8 7.5 21.0 5.6 Computer 4 3.2 8.6 27.5 7.4 Computer 5 3.2 8.6 27.5 7.4 Computer 6 2.8 7.5 21.0 5.6 . . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
unable to repair inobox | Sudheer Mumbai | General Discussion | 1 | February 20th, 2005 12:55 PM |
Need a Formula based on multiple cirteria | comam318 | General Discussion | 1 | November 2nd, 2004 01:04 AM |
sum formula does not tally all values in column | Asleeplessknight | General Discussion | 1 | August 19th, 2004 07:54 PM |
macro to insert a formula in a column | Bryan Kelly | Charts and Charting | 1 | June 6th, 2004 11:31 PM |
Column and Row formula | Bryan Hughes | Worksheet Functions | 2 | October 10th, 2003 08:45 PM |