A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Formula for a column



 
 
Thread Tools Display Modes
  #1  
Old March 11th, 2005, 04:42 AM
comicfly
external usenet poster
 
Posts: n/a
Default 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  
Old March 11th, 2005, 05:57 AM
Biff
external usenet poster
 
Posts: n/a
Default

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  
Old March 11th, 2005, 01:16 PM
comicfly
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 03:10 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.