Solved

excel

Posted on 2015-02-15
7
1,460 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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Server Shares and Excel files 2 14
MS Excel Formula Help 3 35
HELP WITH  INDEX MATCH to look from LEFT TO RIGTH 4 14
Macro show matches 3 35
Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

821 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