contestada

The cell i4, enter a formula to calculate the projected second quarter. enter a formula to multiply the first quarter value by 1 plus the projected increase.

Respuesta :

W0lf93
Answer: =H4*(1+B$12) then drag cell i4 down the parenthesis are important here. The question should have asked you to add 1 to the projected increase THEN multiply your result by the 1st quarter.
fichoh

The required formula is : $h4(1 + $i4).

  • The required formular is to be used in excel as it uses a spreadsheet reference(letter, alphabet and the dollar sign)

  • The projected second quarter increase is given in cell i4
  • Let the first quarter formula be given in cell h4

  • Therefore, to multiply the first quarter value($h4) by (1 plus projected increase)
  • 1 + projected increase = (1 + $i4)

  • The formula becomes ;
  • First quarter value × (1 + projected increase)
  • $h4 × (1 + $i4)

Learn more on excel formulars : https://brainly.com/question/2749852?referrer=searchResults

Otras preguntas