simple formula help

[jimbabwe]

Hi!
I'm new to excel and could use some help. I'm a teacher using excel to record grades.
I want to add 15% of B2, 80% of C2 and 5% of B7 and have the sum show up in D2. I found an article advocating sum product but I was hoping to get away without having to right the weight of each cell in a another cell.

[clabulis]

This should work. Put this in D2:

=(.15*B2)+(.8*C2)+(.05*B7)

[jimbabwe]

Thanks for the quick reply!- I thought I had to write "sum ="

[clabulis]

=SUM is the standard way to sum a contiguous range of cells. For example, If cells A1:A295 had values that you wanted to add, you could write =SUM(A1:A295). In your case, you could write =SUM(.15*B2,.8*C2,.05*B7) as an alternative formula if you prefer.

[FDibbins]

Jim, welcome to the forum

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.