stackov
asked on
excel
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.
Looks like homework which we don't do. If you give it a try we can help.
ASKER
I got F5*$F$4
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
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