Solved

excel

Posted on 2015-02-15
7
1,400 Views
Last Modified: 2015-03-16
In cell F14 determine the weighted response value by entering a formula that multiplies the value in cell F5 by the value in F4. Use a relative reference to the cell F5 and an absolute reference to the cell F4 in the formula.  Use autofill to fill the range F15:F18 with the formula you created in cell F14.
0
Comment
Question by:stackov
  • 2
  • 2
7 Comments
 
LVL 11

Expert Comment

by:Wilder1626
ID: 40611120
Hi

Not sure what you need here but the formula would be like ( Use a relative reference to the cell F5 and an absolute reference to the cell F4 in the formula):
=$F$4*F5
0
 
LVL 46

Expert Comment

by:Martin Liss
ID: 40611122
Looks like homework which we don't do. If you give it a try we can help.
0
 

Author Comment

by:stackov
ID: 40611133
I got F5*$F$4
0
 
LVL 11

Accepted Solution

by:
Wilder1626 earned 500 total points
ID: 40611146
Correct, The absolute to f4 would be
=$F$4*F5

Open in new window

 or
 =F5*$F$4.

Open in new window

What makes the absolute is the dollar sign.  it needs to be in front of the column ID, the row number, or both.

In this case, $F$4 would be an absolute on column F and absolute on row 4
0
 
LVL 46

Expert Comment

by:Martin Liss
ID: 40667525
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Vlookup for in-between dates 4 38
Excel 2013: Default workbook 13 29
Excel VBA 4 27
Excel highlight a cell based on input from another cell 3 14
A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question