w w w (dot)cs(dot)umass(dot)edu(slash)~verts(slash)coins105(slash)quizzes(slash)images(slash)hw10(dot)gif
Using the constants in cells A2:A9, create formulae for cells A12:A15 (surrounded by a dark line)
to compute the corresponding "derived" physical constants indicated in cells B12:B15. Then create
formulae for cells D18:D23 to compute product prices based on the corresponding input values in
A18:A23 and the units in B18:B23. You can use some constants from A2:A9 in your formulae, if
needed. Write formulae only; do not write actual numerical results. For example, if I type any
number for grams of Spike Nails into cell A18, then the cost in dollars for that quantity of Spike
Nails should automatically appear in cell D18. You write the formula to go in D18 in terms of input cell
A18 and the cell addresses of the required conversion constants. Use only cell addresses in your formulae;
do not use actual numbers.
Cell A12: =(A4*A5)
Cell A13: =(A3*A4*A5)
Cell A14: =(A2*A3*A4*A5)
Cell A15: =(A6*A7)
Cell D18: =(A18)*(C7/A15)
Cell D19: =A19*(C6*A7)
Cell D20: =A20*(C5/A6)
Cell D21:
Cell D22:
Cell D23:
So far , I got A12:A15 correct, but D18:D23, I cannot seem to get,I thought i got D18 and D19 correct, but it was not, so i cannot get D20:D23 either. Help please and thank you.
D18=A18/A15*C7
To compute the values for cells D18:D23, we need to use the formulas you provided, along with the cell addresses of the required conversion constants. Let's go step by step:
Cell D18:
The formula to compute the cost in dollars for a given quantity of Spike Nails in grams is:
=(A18)*(C7/A15)
In this formula, A18 represents the input value for grams of Spike Nails, C7 represents the conversion constant for dollars per pound, and A15 represents the conversion constant for pounds per kilogram.
Cell D19:
The formula to compute the cost in dollars for a given quantity of Washer Springs in kilograms is:
=A19*(C6*A7)
In this formula, A19 represents the input value for kilograms of Washer Springs, C6 represents the conversion constant for dollars per kilogram, and A7 represents the conversion constant for pounds per kilogram.
Cell D20:
The formula to compute the cost in dollars for a given quantity of Helical Springs in pounds is:
=A20*(C5/A6)
In this formula, A20 represents the input value for pounds of Helical Springs, C5 represents the conversion constant for dollars per pound, and A6 represents the conversion constant for kilograms per pound.
Cell D21:
To compute the cost in dollars for a given quantity of Bolts in pounds, you can use the formula similar to D20, but with the appropriate input value and conversion constants.
Cell D22:
To compute the cost in dollars for a given quantity of Screws in grams, you can use the formula similar to D18, but with the appropriate input value and conversion constants.
Cell D23:
To compute the cost in dollars for a given quantity of Nuts in kilograms, you can use the formula similar to D19, but with the appropriate input value and conversion constants.
Make sure to substitute the respective input values and conversion constants in the above formulas. If you encounter any specific issues or errors, please let me know, and I'll be happy to assist you further.