Home |
Search |
Today's Posts |
#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 . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Move column values w/o formula | Excel Worksheet Functions | |||
What formula do I use to add to a date column in Excel? | Excel Discussion (Misc queries) | |||
how to enter a formula using column() function for a range | Excel Worksheet Functions | |||
formula to sum all sum calculations in a column | Excel Worksheet Functions | |||
How to populate column with formula based on value in cell | Excel Worksheet Functions |