Applying a 'multiplier' to a cell then adding another?!?! Plz help :-)

[5uropnz]

Hello,

I have a problem in which it states:

Enter a formula in the Score column to calculate an applicant's admission score. Apply the multiplier (found in the Miscellaneous Standards & Filter range) to the student's GPA, and then add that score to the SAT.

I know I need to add the SAT to the GPA, but I don't need to multiply them. I don’t have any other numbers in which to create a formula that would create the GPA then add the SAT. I’m new to Excel 2010. I haven’t figured out where to find the ‘Miscellaneous Standards & Filter’, much less apply the multiplier to the GPA so that I can then add the SAT scores to get my final score.

I’ve Googled, YouTubed, and everything in between that I can think of to find the answer or help I need. The textbook only references how to multiply in various methods.

Please, can someone help simplify this for me?!?!

Thank you!

[FDibbins]

Hi and welcome to the forum

It is against forum policy to do your homework for you (doesnt look like that what you are asking for though, just saying)

What we can do, is assist you withb what you are already trying to do, and guide your efforts.

What have you tried so far, and what were the results?

[dredwolf]

sounds like homework
but the 'Miscellaneous Standards & Firlter' range sounds like either a lookup table or named range within the workbook, and the basic formula should be strait forward -
Multiplier tmes GPA plus SAT

[5uropnz]

Thank you. And I do understand, but I'm not asking for help 'to do' my homework. I just need help figuring out where to find this ''multiplier'' and or the 'Miscellaneous Standards & Filter' is located in Excel 2010...plz

[FDibbins]

Yes, I figured that, thats why I added "(doesnt look like that what you are asking for though, just saying)"

But I also asked what you had tried to do so far, and what results you had?

[dredwolf]

As stated in post #3, that looks like a lookup table or named range..
check the name manager for something similar, and it will tell you where it is located in the 'refers to' input box, assuming of course, that it exists

[5uropnz]

I have looked in various menus for something similar, but all lead me back to just a multiplication formula. I've tried creating my own formula to see if I could come up wit anything that would resemble the outcome I'm looking for, but nothing. I know my other formulas are correct because when I plug in a general number w/o a formula, I get the correct outcome. I just can't figure out what it's talking about. I thought Excel 2010 had something new in it that I just didn't get or couldn't find when it came to applying a multiplier to a cell. Most of the formulas (=IF, =SUM, =*D13+E11, etc...) lead me back to multiplying the two cells together. I don't want that. I know I need to find the product of the GPA so that I can add that to the SAT scores.

I think maybe I'm just not understanding the problem on a whole at this point. I know I need to have whatever the values were that made up the GPA score in the first place, then I need to add that sum to the sum of the SAT scores to come up with my total entry score. But I honestly cannot figure out what the multiplier is that I'm supposed to apply to the GPA, then add the SAT.

I appreciate all of your help! :-)

[dredwolf]

Well, you could always upload a sample file, then we could see for ourselves what is happening, if you manually re-created this from a textbook, or other source, and it had a cd with resource or sample files, you may have missed some data as well...not sure what else to give you to look for though..

[FDibbins]

know I need to find the product of the GPA so that I can add that to the SAT scores.

That almost sounds like you need to look at using the SUMPRODUCT() function?

Do you have any dummy sample data to share?

[5uropnz]

I've checked out the Name Manager, but it refers to the worksheet on a whole.When trying the SUMPRODUCT, it leaves me with another multiplication formula that doesn't have the correct end result.

[dredwolf]

okay...1 more time.. upload a sample workbook we can look at, please
Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[5uropnz]

I'm uploading the dummy spreadsheet which has my formulas, which I've made sure were correct except for in the H column where I'm supposed to apply the multiplier and then add the SAT scores...I just don't get what the multiplier is in order to go from there... Thanks for at least looking at this! :-)

[FDibbins]

I dont see the file?

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[5uropnz]

West Coast Admissions Office.pdfAdmissions_DUMMY.xlsx

[5uropnz]

Thank you!

[dredwolf]

Your multiplier is b13 (600)
this times GPA (columnn E numbers) + SAT (column D numbers) gives the result

if you look at row 10 this is right there :
Miscellaneous Standards & Filter

Edit-

See, that was not so difficult

[5uropnz]

Any ideas of what the multiplier is that's supposed to be applied? :-)

[5uropnz]

But how do I get that? What am I supposed to be looking at here?

[5uropnz]

OMG! I'm so embarrassed! I was over thinking everything!

Thank you so much for your time! I really appreciate it!!!

[dredwolf]

No worries
I've done it myself (several times...lol)
You are welcome

[FDibbins]

you'r welcome. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below my 1st post to you)